Was this helpful?
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.
Note:  The is null predicate is the only predicate that can be used with long varchar and long byte data.
Last modified date: 01/30/2023