Predicate (Transact-SQL)

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.

See Also

Reference

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)

Other Resources

Null Values

Help and Information

Getting SQL Server 2005 Assistance