ISNULL (TSQL Function)

Returns the expression if it is not NULL. Else, returns the replacement value.

Syntax

ISNULL ( expression , replacement_value )

Arguments

expression
is an expression of any type.
replacement_value
if expression is NULL, replacement_value will be returned.

Return Types

Returns the same type as expression.

Examples

DECLARE @a INT; -- @a is NULL

PRINT ISNULL(@a, 123);
PRINT ISNULL(9000, 123);

The result is:

123
9000