predicates.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	helpviewer_keywords	dev_langs	monikerRange
Predicates	Predicates are expressions, used in search conditions, that evaluate to TRUE, FALSE, or UNKNOWN.	VanMSFT	vanto	randolphwest	07/09/2024	sql	t-sql	reference	ignite-2024	HAVING clause, predicates FROM clause, predicates unknown data [SQL Server] TRUE WHERE clause, predicates FALSE predicates [full-text search] expressions [SQL Server], predicates	TSQL	>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

Predicates

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]

A predicate 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.

For more information, including how to specify a search condition, see Search condition.

[!INCLUDE ssNoVersion] provides the following predicates:

• CONTAINS (Transact-SQL)
• FREETEXT (Transact-SQL)
• IS [NOT] DISTINCT FROM (Transact-SQL)
• IS NULL (Transact-SQL)

Related content

• BETWEEN (Transact-SQL)
• EXISTS (Transact-SQL)
• IN (Transact-SQL)
• LIKE (Transact-SQL)
• Search condition (Transact-SQL)