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.
Transact-SQL Syntax Conventions
boolean_expression AND boolean_expression
Is any valid expression that returns a Boolean value: TRUE, FALSE, or UNKNOWN.
The following chart shows the outcomes when you compare TRUE and FALSE values by using the AND operator.
Returns TRUE when both expressions are TRUE.