Performs a logical disjunction on two expressions.
result=expression1 Or expression2
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 (IIS is Null) |
Null | True | True |
Null | False | FALSE (IIS is Null) |
Null | Null | Null |
The Or operator also performs a bitwise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result according to the following table:
If bit in expression1 is | And bit in expression2 is | Then result is |
0 | 0 | 0 |
0 | 1 | 1 |
1 | 0 | 1 |
1 | 1 | 1 |
Performs a logical conjunction on two expressions.
result= expression1 And expression2
If expression1 is | And expression2 is | The result is |
True | True | True |
True | False | False |
True | Null | False(IIS IS NULL) |
False | True | False |
False | False | False |
False | Null | Fase |
Null | True | False(IIS IS NULL) |
Null | False | Fase |
Null | Null | Null |
The And operator also performs a bitwise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result according to the following table:
If bit in expression1 is | And bit in expression2 is | The result is |
0 | 0 | 0 |
0 | 1 | 0 |
1 | 0 | 0 |
1 | 1 | 1 |