AND
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
AND
0 out of 5 stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
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.
See Also
Updated
ByJason Lee
Was this article helpful?
0 out of 5 stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
5
2 Responses
OR and IN command inserted.
Falta o OR e o IN *************************