is there an updated approach on how to use the COALESCE keyword?
Or if there is a NEW keyword that will replace COALESCE on SQL 2005/2003?
Coalesce function is available since SQL Server 2000 and returns the first nonnull expression among its N arguments.
Here is the syntax:
COALESCE(expression1 [,expression2,expression3,...expressionN ])
Think about this function as a CASE WHEN but much simplier.
Take a deep look at http://msdn.microsoft.com/en-us/library/aa258244(SQL.80).aspx