AND Operator

Performs a logical conjunction on two expressions.

Syntax

result = expression1 And expression2

Arguments:

• Result: Any Boolean value.

• expression1: Any expression.

• expression2: Any expression.

Remarks

If, and only if, both expressions evaluate to True, result is True. If either expression evaluates to False, result is False. The following table illustrates how result is determined:

Table 11-29 AND Operator Expressions and Results

If expression1 is	And expression2 is	Then result is
True	True	True
True	False	False
True	Null	False
False	True	False
False	False	False
False	Null	False
Null	True	False
Null	False	False
Null	Null	False

The following examples illustrate the use of AND operator.

Example 1:

Dim expr1, expr2, result
expr1 = True
expr2 = True
result = expr1 And expr2
'result -> true

Example 2:

Dim expr3, expr4, result1
expr3 = True
expr4 = False
result1 = expr3 And expr4
'result1 -> false

Example 3:

Dim expr5, expr6, result2
expr5 = False
expr6 = True
result2 = expr5 And expr6
'result2 -> false

Example 4:

Dim expr7, expr8, result3
expr7 = False
expr8 = False
result3 = expr7 And expr8
'result3 -> false

Example 5:

Dim expr9, expr10, result4
expr9 = False
expr10 = Null
result4 = expr9 And expr10
'result4 -> false

Example 6:

Dim expr11, expr12, result5
expr11 = Null
expr12 = False
result5 = expr11 And expr12
'result5 -> false