ASA SQL Reference
  SQL Language Elements
    Search conditions

IS NULL conditions

The syntax for IS NULL conditions is as follows:

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.

Standards and compatibility 

• The IS NULL condition is compatible between Adaptive Server Enterprise and Adaptive Server Anywhere.