Sybase Adaptive Server Anywhere - Exists Conditions; Is Null Conditions

Search conditions
244
♦ IN conditions are compatible between Adaptive Server Enterprise and
Adaptive Server Anywhere.
EXISTS conditions
The syntax for EXISTS conditions is as follows:
... EXISTS( subquery )
The EXISTS condition is TRUE if the subquery result contains at least one
row, and FALSE if the subquery result does not contain any rows. The
EXISTS condition cannot be UNKNOWN.
♦ The EXISTS condition is compatible between Adaptive Server
Enterprise and Adaptive Server Anywhere.
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.
♦ The IS NULL condition is compatible between Adaptive Server
Enterprise and Adaptive Server Anywhere.
Truth value conditions
The syntax for truth-value conditions is as follows:
... IS [ NOT ] truth-value
Without the NOT keyword, the 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 condition, but leaves UNKNOWN unchanged.
♦ Adaptive Server Anywhere only supports truth-valued conditions.
Compatibility
Compatibility
Compatibility
Compatibility