Description

Predicate operators 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.

Predicates must be used together with one of the following operators which are evaluating the return value:

• CASE WHEN
• FILTER
• Pull-Up-Functions