Home Forums SQL Server 2008 T-SQL (SS2K8) Best Practice : coalesce vs. isnull? RE: Best Practice : coalesce vs. isnull?
BaldingLoopMan
SSCertifiable
Points: 6378
More actions
December 14, 2009 at 8:26 am
#1091980
actually u can use isnull in all situations if u wanted to. A coalesce is a nested isnull.
coalesce(custname, last, first) = isnull( isnull( custname, last ), first )
Therefore a coalesce is basically a nested isnull.