How to Use Coalesce

The coalesce function returns the first non null parameter, is a sort of isnull function.

Select name2, coalesce(name2 , ’xxxxxx’) coalesce from employee;
name2 coalesce
John John
Peter Peter
null xxxxxx

IN THIS PAGE