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.
| BETWEEN | IN |
| CONTAINS | LIKE |
| EXISTS | IS [NOT] NULL |
| FREETEXT | Search Condition |