Predicate functions and operators check if the input argument satisfies a condition.
- Predicate operators may match the values of a column with a list of match values (IN) or a match pattern (LIKE) and return true if the value of a column matches.
- The BETWEEN operator matches an inclusive range between two given values.
- In contrast to the ISNULL function, which returns an INT, the IS NULL operator returns true if the input is NULL, and false otherwise.
The output of
IS NULL can be negated by using
NOT BETWEEN and
IS NOT NULL respectively.
Predicate operators can be combined with logical operators to more complex boolean expressions.