The syntax for IS NULL conditions is:
expression IS [ NOT ] NULL
Without the NOT keyword, the IS NULL condition is TRUE if the expression is the NULL value, and FALSE otherwise. The NOT keyword reverses the meaning of the condition.
The IS NULL condition is compatible between Adaptive Server Enterprise and Sybase IQ.
