| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Logical Operators (Transact-SQL) |
Logical Operators (Transact-SQL) |
rwestMSFT |
randolphwest |
03/06/2017 |
sql |
t-sql |
reference |
|
|
[!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 | TRUE if some of a set of comparisons are TRUE. |