AND

AND

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

AND

Performs a Boolean AND of two logic expressions.

Syntax

expression1 AND expression2

Parameters

expression1A logical expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses.
expression2A 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 ANDExpression1
TrueFalse
Expression2TrueTrueFalse
FalseFalseFalse

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

[NOT] BETWEEN

NOT

XOR

OR

IN

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
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

2 Responses

  1. Jason Lee says:

    OR and IN command inserted.

  2. Livio Augusto Taufer says:

    Falta o OR e o IN *************************

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish