Search conditions can be combined using AND, OR, and NOT.
Conditions are combined using AND as follows:
condition1 AND condition2
The combined condition is TRUE if both conditions are TRUE, FALSE if either condition is FALSE, and UNKNOWN otherwise.
Conditions are combined using OR as follows:
condition1 OR condition2
The combined condition is TRUE if either condition is TRUE, FALSE if both conditions are FALSE, and UNKNOWN otherwise.
The AND and OR operators are compatible between Sybase IQ and Adaptive Server Enterprise.
