IS [NOT] NULL (TSQL Operator)
Checks if a specified expression is NULL.
Syntax
expression IS [NOT] NULL
Arguments
- expression
- is an expression of any type.
Return Types
Returns a bool
value.
Remarks
Returns True if expression is NULL. Else, returns False.
IS NOT NULL
returns the negated result of IS NULL
.
Examples
DECLARE @a INT; -- value of @a is NULL
PRINT @a IS NULL;
PRINT @a IS NOT NULL;
SET @a = 123;
PRINT @a IS NULL;
The result is:
true
false
false