Transact-SQL reference for COALESCE, which returns the value of the first expression that does not evaluate to NULL. Evaluates the arguments in order and returns the current value of the first ...
Evaluates the arguments in order and returns the current value of the first expression that initially doesn't evaluate to NULL. For example, SELECT COALESCE(NULL, NULL, 'third_value', 'fourth_value'); ...