NOT
Syntax
NOT(<Boolean>)
Description
Checks the Boolean arguments of a column and gives the opposite Boolean result. If the argument is true the result is false. If the argument is false the result is true. If you enter null, the result is null.
Instead of using the NOT() function you can also use the ! operator.
Examples
Checks the column1 Boolean expression and gives the opposite result.
| Column1 | Result |
|---|---|
| true | false |
| true | false |
| false | true |
| false | true |
| null | null |