Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

COALESCE is equivalent to a CASE expression that returns the first NOT NULL expression in a list of expressions

COALESCE(expression1, expression2, ... expressionN)