Conditions A condition specifies a combination of one or more expressions and logical operators that evaluates to either TRUE, FALSE, or UNKNOWN. You can use a condition in the Where clause of the Delete, Select, and Update statements; and in the Having clauses of Select statements. The following describes supported conditions. Table 28. Conditions Condition Description Simple comparison Specifies a comparison with expressions or subquery results. = , !=, <>, < , >, <=, <= Group comparison Specifies a comparison with any or all members in a list or subquery. [= , !=, <>, < , >, <=, <=] [ANY, ALL, SOME] Membership Tests for membership in a list or subquery. [NOT] IN Range Tests for inclusion in a range. [NOT] BETWEEN NULL Tests for nulls. IS NULL, IS NOT NULL EXISTS Tests for existence of rows in a subquery. [NOT] EXISTS LIKE Specifies a test involving pattern matching. [NOT] LIKE Compound Specifies a combination of other conditions. CONDITION [AND/OR] CONDITION