The COALESCE function in SQL returns the first non-NULL expression among its arguments.

Table Info

Name

Bussiness_Phone


Cell_Phone

Home_Phone

Gaurang

5646


95855

456

Jinal

Null


783

null

Brijesh

Null


Null

465465

If You Used Case When the Query Is :

Select Name,Case When Business_Phone is null Then Case When Cell_Phone is null Then Home_Phone Else Cell_Phone End
Else Business_Phone End As Phone From test


If You Used Isnull Function :

Select Name,Isnull(Business_Phone,Isnull(Cell_Phone,Home_Phone)) From test

If You Used Coalesce Function :

Select Client_Name,Coalesce(Business_Phone,Cell_Phone,Home_Phone) From test

-------------------------------------

Thanks & Regards

Gaurang Upadhyay

Sr Developer