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 | ||
| True | False | ||
| Expression2 | True | True | False |
| 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.