Sql server : COALESCE function with example

Here in this article I am going to explain COALESCE function of sql server with example.

Description:
The COALESCE function takes comma separated list of arguments of same data type sbut returns the value of the first non-NULL argument.

Syntax:
COALESCE( expression1,[....n] )

 Example:
I have created a table Employee and insert some dummy data into it. 

Sql server  : COALESCE function with example

Now you can see in last 2 record status of employee is null. I want to replace null with 0. Run the below given query and check output.

select  name,COALESCE(Status,0) as 'status' from Employee

Output:

Sql server  : COALESCE function with example

  


0 Comments