Export (0) Print
Expand All

IS [NOT] NULL

SQL Server 2000

Determines whether or not a given expression is NULL.

Syntax
expression IS [ NOT ] NULL 
Arguments
expression
Is any valid expression in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE).
NOT
Specifies that the Boolean result be negated. The predicate reverses its return values, returning TRUE if the value is NOT NULL, and FALSE if the value is NULL.
Result Types

bit

Return Code Values

If the value of expression is NULL, IS NULL returns TRUE; otherwise, it returns FALSE.

If the value of expression is NULL, IS NOT NULL returns FALSE; otherwise, it returns TRUE.

Remarks

To determine whether an expression is NULL, use IS NULL or IS NOT NULL rather than comparison operators (such as = or !=). Comparison operators return UNKNOWN if either or both arguments are NULL.

Show:
© 2014 Microsoft