Predicates
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric
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.
SQL Server provides the following predicates:
- CONTAINS (Transact-SQL)
- FREETEXT (Transact-SQL)
- IS [NOT] DISTINCT FROM (Transact-SQL)
- IS NULL (Transact-SQL)
Related content
Tagasiside
https://aka.ms/ContentUserFeedback.
Varsti tulekul: 2024. aasta jooksul tühistame GitHubi probleemide funktsiooni sisutagasiside mehhanismina ja asendame selle uue tagasisidesüsteemiga. Lisateabe saamiseks vtEsita ja vaata tagasisidet