This operator is used to perform logical negation on an expression.
result = Not expression
The following table shows how Not determines result.
If expression is |
The result is |
| True | False |
| False | True |
| Null | Null |
In addition, the Not operator inverts the bit values of any variable and sets the corresponding bit in result. The following table shows how Not determines the corresponding bit.
Bit in expression |
Bit in result |
| 0 | 1 |
| 1 | 0 |