Predicates
statements #tsql#statements
Analytics Platform System (PDW)
SQL analytics endpoint in
Microsoft Fabric
Warehouse in Microsoft Fabric
A
predicate
is an expression that evaluates to
,
, or. 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.
provides the following predicates:
CONTAINS (Transact-SQL)
FREETEXT (Transact-SQL)
IS [NOT] DISTINCT FROM (Transact-SQL)
IS NULL (Transact-SQL)
BETWEEN (Transact-SQL)
EXISTS (Transact-SQL)
IN (Transact-SQL)
LIKE (Transact-SQL)
Search condition (Transact-SQL)