4.2. Predicates

In SQL, predicates can appear in CHECK constraints, WHERE and clauses, CASE expressions, the IIF() function and in the ON condition of clauses.