What is the use of SQL COALESCE Function??
How to implement this??
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pradeep SahooPosted Oct 29, 2016, 7:09 AM
Midhun TpPosted Oct 29, 2016, 12:56 AM
In SQL Server, the COALESCE function returns the first non-null expression in the list. If all expressions evaluate to null, then the COALESCE function will return null.
Select COALESCE(null,null,1,2,null) statement will return result as 1
Please have a look at below articles -