Is an expression that evaluates to TRUE, FALSE, or UNKNOWN. Predicates are used in the search condition of WHERE clauses and HAVING clauses, and the join conditions of FROM clauses.
See Also
BETWEEN
CONTAINS
EXISTS
FREETEXT
IN
IS [NOT] NULL
LIKE
Search Condition
