Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
expression IS [ NOT ] NULL
Without the NOT keyword, the IS NULL search condition is TRUE if the expression is the NULL value, and FALSE otherwise. The NOT keyword reverses the meaning of the search condition.
SQL/2008 Core feature.