Conditions with Logical Operators

Combine search conditions in subqueries using AND, OR, and NOT.

Conditions are combined using AND as follows:

condition1 AND condition2

If both conditions are TRUE, the combined condition is TRUE. If either condition is FALSE, the combined condition is FALSE. If otherwise, the combined condition is UNKNOWN.

Conditions are combined using OR as follows:

condition1 OR condition2

If both conditions are TRUE, the combined condition is TRUE. If either condition is FALSE, the combined condition is FALSE. If otherwise, the combined condition is UNKNOWN. There is no guaranteed order as to which condition, condition1 or condition2, is evaluated first.

Compatibility

The AND and OR operators are compatible between Sybase IQ and Adaptive Server Enterprise.