Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

AND (Transact-SQL)

SQL Server 2008

Combines two Boolean expressions and returns TRUE when both expressions are TRUE. When more than one logical operator is used in a statement, the AND operators are evaluated first. You can change the order of evaluation by using parentheses.

Topic link iconTransact-SQL Syntax Conventions

Copy 
boolean_expression AND boolean_expression
boolean_expression

Is any valid expression that returns a Boolean value: TRUE, FALSE, or UNKNOWN.

Returns TRUE when both expressions are TRUE.

The following chart shows the outcomes when you compare TRUE and FALSE values by using the AND operator.

 

TRUE

FALSE

UNKNOWN

TRUE

TRUE

FALSE

UNKNOWN

FALSE

FALSE

FALSE

FALSE

UNKNOWN

UNKNOWN

FALSE

UNKNOWN
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ