This operator is used to perform a logical implication on two expressions.
result = expression1 Imp expression2
The following table shows how Imp determines result.
If expression1 is |
And expression2 is |
The result is |
True | True | True |
True | False | False |
True | Null | Null |
False | True | True |
False | False | True |
False | Null | True |
Null | True | True |
Null | False | Null |
Null | Null | Null |
The Imp operator performs a bitwise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result. The following table shows how Imp determines the corresponding bit.
If the bit in expression1 is |
And the bit in expression2 is |
The result is |
0 | 0 | 1 |
0 | 1 | 1 |
1 | 0 | 0 |
1 | 1 | 1 |