predicates.md

title	Predicates | Microsoft Docs
ms.custom
ms.date	03/16/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	HAVING clause, predicates FROM clause, predicates unknown data [SQL Server] TRUE WHERE clause, predicates FALSE predicates [full-text search] expressions [SQL Server], predicates
ms.assetid	ddbc530c-f44d-4551-9ca3-3430258eb6c0
author	VanMSFT
ms.author	vanto

Predicates

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

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.

In This Section

[!INCLUDEssNoVersion] provides the following predicates.

CONTAINS
FREETEXT
IS [NOT] NULL

See Also

BETWEEN (Transact-SQL)
EXISTS (Transact-SQL)
IN (Transact-SQL)
LIKE (Transact-SQL)
Search Condition (Transact-SQL)