---
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
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]

  Is an expression that evaluates to TRUE, FALSE, or UNKNOWN. Predicates are used in the search condition of [WHERE](../../t-sql/queries/where-transact-sql.md) clauses and [HAVING](../../t-sql/queries/select-having-transact-sql.md) clauses, the join conditions of [FROM](../../t-sql/queries/from-transact-sql.md) clauses, and other constructs where a Boolean value is required.  
  
## In This Section  
 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] provides the following predicates.  
  
||  
|-|  
|[CONTAINS](../../t-sql/queries/contains-transact-sql.md)|  
|[FREETEXT](../../t-sql/queries/freetext-transact-sql.md)|  
|[IS [NOT] NULL](../../t-sql/queries/is-null-transact-sql.md)|  
  
## See Also  
 [BETWEEN (Transact-SQL)](../../t-sql/language-elements/between-transact-sql.md)   
 [EXISTS (Transact-SQL)](../../t-sql/language-elements/exists-transact-sql.md)   
 [IN (Transact-SQL)](../../t-sql/language-elements/in-transact-sql.md)   
 [LIKE (Transact-SQL)](../../t-sql/language-elements/like-transact-sql.md)   
 [Search Condition (Transact-SQL)](../../t-sql/queries/search-condition-transact-sql.md)