<--- --------------------------------------------------------------------------------------- ---- Blog Entry: SQL COALESCE() Like ISNULL() On Steroids ... With Caveats Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:195.view Date Posted: Aug 4, 2006 at 5:04 PM ---- --------------------------------------------------------------------------------------- ---> SELECT COALESCE( -- Force null value. NULL, -- Text expression 'sometime', -- System date/time. getDate() ) AS began_dating FROM girl