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 ...
operand is one of the following: constant is a number or a quoted character string (or other special notation) that indicates a fixed value. Constants are also called literals. Constants are described ...