Choose Category
COALESCE(Argument list,['default value'])
COALESCE(col1, col2, col3, 0)
SELECT COALESCE(Country,'US') as Output
SELECT Name, COALESCE (HomePhone, OfficePhone, cellPhone) FROM PhoneDirectory;
SELECT Name, COALESCE (HomePhone, OfficePhone, cellPhone,'No Phone') FROM PhoneDirectory;
SELECT (COALESCE(100,0)) * 5;