Performs a Boolean AND of two logic expressions.
expression1 AND expression2
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. |
Logical, as follows:
Truth Table for Boolean AND | Expression1 | ||
True | False | ||
Expression2 | True | True | False |
False | False | False |
This AND is not the same as the AND used with the BETWEEN operator.
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.