OR Operator
Performs a logical disjunction on two expressions.
Syntax
result = expression1 Or expression2
Arguments:
-
Result: Any Boolean Value.
-
expression1: Any expression.
-
expression2: Any expression.
Remarks
If either or both expressions evaluate to True, result is True. The following table illustrates how result is determined:
Table 11-31 OR Operator Expressions and Results
| If expression1 is | And expression2 is | Then result is |
|---|---|---|
| True | True | True |
| True | False | True |
| True | Null | True |
| False | True | True |
| False | False | False |
| False | Null | False |
| Null | True | True |
| Null | False | False |
| Null | Null | False |
The following examples illustrate the use of OR operator.
Example 1:
Dim expr1, expr2, result
expr1 = True
expr2 = True
result = expr1 Or expr2
'result -> True
Example 2:
Dim expr3, expr4, result1
expr3 = True
expr4 = False
result1 = expr3 Or expr4
'result1 -> True
Example 3:
Dim expr5, expr6, result2
expr5 = True
expr6 = Null
result2 = expr5 Or expr6
'result2 - > True
Example 4:
Dim expr7, expr8, result3
expr7 = False
expr8 = True
result3 = expr7 Or expr8
'result3 -> True
Example 5:
Dim expr9, expr10, result4
expr9 = False
expr10 = False
result4 = expr9 Or expr10
'result4 -> False
Example 6:
Dim expr11, expr12, result5
expr11 = Null
expr12 = True
result5 = expr11 Or expr12
'result5 -> True