AND (T-SQL)

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

Syntax

boolean_expression AND boolean_expression

Arguments

boolean_expression

Is any valid Microsoft® SQL Server™ expression that returns a Boolean value: TRUE, FALSE, or UNKNOWN.

Result Types

Boolean

Result Value

Returns TRUE when both of the expressions are TRUE.

Remarks

This chart outlines the outcomes when you compare TRUE and FALSE values using the AND operator.

See Also