/
Not function
Not function
Returns the Not of the logical value of an expression. If the value of expression is true
, the Not function returns a value of false (0)
. If the value of expression is false
, the NOT
function returns a value of true (1)
. A numeric expression that evaluates to 0
is a logical value of false
. A numeric expression that evaluates to anything else, other than the null
value, is a logical true
. An empty string is logically false
. All other string expressions, including strings that include an empty string, spaces, or the number 0
and spaces, are logically true
.
Namespace
logical
Input
expression
Output
number (short)
Example
If mynumber
contains the number 352
, then the following two functions are equivalent, and return the string "101100000"
.
set-column val logical:Not(5-5)
set-column val logical:Not(5+5)
set-column val logical:Not('value')
, multiple selections available,
Related content
IsNotNull function
IsNotNull function
More like this
NullToValue function
NullToValue function
More like this
NullToEmpty function
NullToEmpty function
More like this
NullToZero function
NullToZero function
More like this
IsNull JSON function
IsNull JSON function
More like this
BitCompress function
BitCompress function
More like this
Created in 2020 by Google Inc.