Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
boolean_expression AND boolean_expression
Arguments
- boolean_expression
Is any valid expression that returns a Boolean value: TRUE, FALSE, or UNKNOWN.
Remarks
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 |
Result Types
Boolean
Result Value
Returns TRUE when both expressions are TRUE.
See Also
Reference
Functions (Transact-SQL)
Operators (Transact-SQL)
SELECT (Transact-SQL)
WHERE (Transact-SQL)