AND

Performs a Boolean AND of two logic expressions.

Syntax

expression1 AND expression2

Parameters

expression1	A logical expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses.
expression2	A logical expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses.

Return Value

Logical, as follows:

Truth Table for Boolean AND		Expression1
Truth Table for Boolean AND		True	False
Expression2	True	True	False
Expression2	False	False	False

Comments

This AND is not the same as the AND used with the BETWEEN operator.

Example

ClaimType = 'Auto' and DamageCost > 3000\
and LastName= 'Andretti'

This Boolean expression is logically true only when the insurance claim type is Auto, the cost of the damage is greater than 3,000, and the last name of the person making the claim is Andretti. Otherwise, the Boolean expression is logically false.