Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Language Elements » Search conditions

EXISTS search condition Next Page

IS NULL and IS NOT NULL search conditions

The syntax for the IS NULL search conditions is as follows:

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.