Search conditions can be combined using the AND or OR operators. You can also negate them using the NOT operator, or test whether an expression would evaluate to true, false, or unknown, using the IS operator.
AND operator The AND operator is placed between search conditions as follows:
.. WHERE condition1 AND condition2
When using AND, the combined condition is TRUE if both conditions are TRUE, FALSE if either condition is FALSE, and UNKNOWN otherwise.
OR operator The OR operator is placed between search conditions as follows:
.. WHERE condition1 OR condition2
When using OR, the combined condition is TRUE if either condition is TRUE, FALSE if both conditions are FALSE, and UNKNOWN otherwise.
NOT operator The NOT operator is placed before a condition to negate the condition, as follows:
.. WHERE NOT condition
The NOT condition is TRUE if condition is FALSE, FALSE if condition is TRUE, and UNKNOWN if condition is UNKNOWN.
IS operator The IS operator is placed between an expression and the truth value you are testing for. The syntax for the IS operator is as follows:
expression IS [ NOT ] truthvalue
The IS condition is TRUE if the expression evaluates to the supplied truthvalue, which must be one of TRUE, FALSE, UNKNOWN, or NULL. Otherwise, the value is FALSE.
For example, 5*3=15 IS TRUE
tests whether the expression 5*3=15
evaluates to TRUE.
See also: Threevalued logic.
Discuss this page in DocCommentXchange.

Copyright © 2010, iAnywhere Solutions, Inc.  SQL Anywhere 12.0.0 