NOT
- Juliane Wetzel
Owned by Juliane Wetzel
Feb 07, 2020
Loading data...
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 |