<--- --------------------------------------------------------------------------------------- ---- Blog Entry: SQL COALESCE() Very Cool, But Slower Than ISNULL() Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:196.view Date Posted: Aug 4, 2006 at 5:25 PM ---- --------------------------------------------------------------------------------------- ---> SELECT id, COALESCE( date_created, getDate() ) AS date_created FROM web_stats_hit WHERE COALESCE( date_created, getDate() ) IS NOT NULL AND COALESCE( id, 0 ) IS NOT NULL SELECT id, ISNULL( date_created, getDate() ) AS date_created FROM web_stats_hit WHERE ISNULL( date_created, getDate() ) IS NOT NULL AND ISNULL( id, 0 ) IS NOT NULL