COALESCE Function in TSQL
|
Raj
648
Points
26
Posts
|
Hi, What does mean by COALESCE? When and how we can use it in T-SQL?
Thanks...
Views:
8980
Total Answered: 1 Total Marked As Answer: 0 Posted On: 02-May-2016 02:20 Share: 
|
Answers
|
Rahul M...
4960
Points
31
Posts
|
Evaluates the arguments in order in which they are putted and returns the first non-NULL expression value. If all expression have NULL value then it will return NULL. Syntax: COALESCE ( expression [ ,...n ] )
-- Azure SQL Data Warehouse and Parallel Data Warehouse COALESCE ( expression [ ,...n ] )
Example: SELECT Name, Class, Color, ProductNumber,
COALESCE(Class, Color, ProductNumber) AS FirstNotNull
FROM MyProduct;
Posted On:
04-May-2016 19:08
|
