This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Is an expression that evaluates to TRUE, FALSE, or UNKNOWN. Predicates are used in the search condition of WHERE clauses and HAVING clauses, the join conditions of FROM clauses, and other constructs where a Boolean value is required.
BETWEEN (Transact-SQL)
CONTAINS (Transact-SQL)
EXISTS (Transact-SQL)
FREETEXT (Transact-SQL)
IN (Transact-SQL)
IS [NOT] NULL (Transact-SQL)
LIKE (Transact-SQL)
Search Condition (Transact-SQL)
Null Values