COALESCE FUNCTION??

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?

thank you

Hi reymon.

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