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