Predicate

 Description

Comparison

 Compares two values.

BETWEEN

 Compares a value to a range formed by two values.

EXISTS

 Determines whether a value exists in a look-up table.

IN

 Determines whether a value exists in a list of values or a table.

LIKE

 Compares, in part or in whole, one value with another.

IS NULL

 Compares a value with an empty, or NULL, value.

SOME/ANY/ALL

 Performs quantified comparisons.