logical-operators-transact-sql.md

title	Logical Operators (Transact-SQL)
description	Logical operators test for the truth of some condition.
author	rwestMSFT
ms.author	randolphwest
ms.date	01/29/2026
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
helpviewer_keywords	operators [Transact-SQL], logical testing truth truth testing TRUE FALSE logical operators [SQL Server], Transact-SQL
dev_langs	TSQL

Logical operators (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Logical operators test for the truth of some condition. Logical operators, like comparison operators, return a Boolean data type with a value of TRUE, FALSE, or UNKNOWN.

Operator	Meaning
ALL	TRUE if all of a set of comparisons are TRUE.
AND	TRUE if both Boolean expressions are TRUE.
ANY	TRUE if any one of a set of comparisons are TRUE.
BETWEEN	TRUE if the operand is within a range.
EXISTS	TRUE if a subquery contains any rows.
IN	TRUE if the operand is equal to one of a list of expressions.
LIKE	TRUE if the operand matches a pattern.
NOT	Reverses the value of any other Boolean operator.
OR	TRUE if either Boolean expression is TRUE.
SOME | ANY	TRUE if some of a set of comparisons are TRUE.

Related content

• Operator precedence (Transact-SQL)