SQL COALESCE Function

Question

What is the use of SQL COALESCE Function?? How to implement this??

Pradeep Sahoo · Answer

Please read the link http://www.codeproject.com/Tips/605339/Using-Coalesce-in-sqlserver

Midhun T P · Answer

Hi 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(nullnull12null) statement will return result as 1 It is used for checking non null values in expressions or columns. Please have a look at below articles - http://www.1keydata.com/sql/sql-coalesce.html https://www.techonthenet.com/sql_server/functions/coalesce.php