Used to perform a logical disjunction on two expressions.
result = expression1 Or expression2
The Or operator syntax has these parts:
|
Part |
Description |
|
result |
Any numeric variable. |
|
expression1 |
Any expression. |
|
expression2 |
Any expression. |
If either or both expressions evaluate to True, result is True. The following table illustrates how result is determined:
|
If expression1 is |
And expression2 is |
The result is |
|
True |
True |
True |
|
True |
False |
True |
|
True |
Null |
True |
|
False |
True |
True |
|
False |
False |
False |
|
False |
Null |
Null |
|
Null |
True |
True |
|
Null |
False |
Null |
|
Null |
Null |
Null |
The Or operator also performs a bit-wise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result according to the following truth table:
|
If bit in expression1 is |
And bit in expression2 is |
The result is |
|
0 |
0 |
0 |
|
0 |
1 |
1 |
|
1 |
0 |
1 |
|
1 |
1 |
1 |
Operator Precedence.
This example uses the Or operator to perform logical disjunction on two expressions.
A = 10: B = 8: C = 6: D = Null ' Initialize variables.= A > B Or B > C ' Returns True.= B > A Or B > C ' Returns True.= A > B Or B > D ' Returns True.= B > D Or B > A ' Returns Null.= A Or B ' Returns 10 (bit-wise comparison).