What is the use of COALESCE function in SQL Server ?

 Posted by Chikul on 12/21/2009 | Category: Sql Server Interview questions | Views: 2162

Returns the first not null expression among its arguments.

If X is Null then It'll check for Y,
If Y is Null It'll Check for Z.

Let X is NULL, Y='5' and Z='9'
Here Output is : Y

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response