Predicates Overview
A predicate is a tri-state (true, false, unknown) Boolean expression. Predicates are composed of a search term contained within a search expression.
A predicate can take one of six forms:

EXISTS

COMPARE

BETWEEN

IN

LIKE

NULL
See the next chapters in this topic for additional information about each predicate.