COALESCE System Function TSQL Tutorial

If the expression is null, then returns a default value.

COALESCE Syntax:

COALESCE ( expression, ...n_value )

COALESCE Example:

select COALESCE(null,11) as Value;

Value
11

See also: T-SQL Functions -> HOST_ID | HOST_NAME | ISNULL | ISNUMERIC | NULLIF