What are Predicates?

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.

predicate.bmp
 

For more information, see:

 

EXISTS Predicate

COMPARISON Predicate

BETWEEN Predicate

IN Predicate

LIKE Predicate

NULL Predicate