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

IS NULL and IS NOT NULL search conditions Next Page

Truth value search conditions


The syntax for truth-value search conditions is as follows:

IS [ NOT ] truth-value

Without the NOT keyword, the search condition is TRUE if the condition evaluates to the supplied truth-value, which must be one of TRUE, FALSE, or UNKNOWN. Otherwise, the value is FALSE. The NOT keyword reverses the meaning of the search condition, but leaves UNKNOWN unchanged.

Standards and compatibility