This operator is used to perform a logical disjunction on two expressions.
result = expression1 Or expression2
If either or both expressions evaluate to True, result is True. The following table shows how Or determines result.
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 bitwise comparisonof identically positioned bits in two numeric expressions and sets the corresponding bit in result. The following table shows how Or determines the corresponding bit.
If the bit in expression1 is |
And the bit in expression2 is |
The result is |
0 | 0 | 0 |
0 | 1 | 1 |
1 | 0 | 1 |
1 | 1 | 1 |