AND (TSQL Operator)

Performs a logical AND of two boolean expressions.

Syntax

bool_expr AND bool_expr

Arguments

bool_expr

is an expression of type bool.
Such expression can be produced e.g. by comparison operators like =, >, etc.

Return Types

Returns a result of type bool.

Remarks

In SQL, logical operators evaluate to True, False or NULL, with a 3-valued logic.

This table shows the results for the logical AND operator.

	True	False	NULL
True	True	False	NULL
False	False	False	False
NULL	NULL	False	NULL

Examples

PRINT 1=1 AND 2=2;
PRINT 1=1 AND 2=3;
PRINT 1=1 AND 2=NULL;

The result is:

true
false
<NULL>