Export (0) Print
Expand All
Expand Minimize

IS [NOT] NULL (SQL Server Compact Edition)

Determines whether or not a given expression is NULL.

Note:
ISNULL() is not a supported function in Microsoft SQL Server 2005 Compact Edition.



            expression IS [ NOT ] NULL 

expression

Any valid expression in Microsoft SQL Server 2005 Compact Edition.

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.

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.

SELECT column_name FROM table_name WHERE column_name IS NOT NULL

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft