Home Forums SQL Server 2005 SQL Server Newbies Coalesce returning 1 value only RE: Coalesce returning 1 value only
matt6288
SSCertifiable
Points: 5058
More actions
September 16, 2009 at 12:21 pm
#1054661
From BOL: COALESCE Returns the first nonnull expression among its arguments.
So in your case the first argument will always be nonnull so it will be the one returned.