Predicates
Predicates are keywords that specify a relationship between two expressions:
expression_1 predicate expression_2
OpenSQL supports the following types of predicates:
• [not] like
• [not] between
• [not] in
• all | any | some
• exists
• is [not] null
The second expression can be a subquery. If the subquery does not return any rows, then the comparison evaluates to false. For details about subqueries, see
Subqueries (see page
Subqueries).
Note: The is null predicate is the only predicate that can be used with long varchar and long byte data.