- Categories:
BOOLNOT¶
Computes the Boolean NOT of a single numeric expression. In accordance with Boolean semantics:
Non-zero values (including negative numbers) are regarded as True.
Zero values are regarded as False.
As a result, the function returns:
Trueif the expression is zero.Falseif the expression is non-zero.NULLif the expression is NULL.
Syntax¶
BOOLNOT(expr)
Copy
Examples¶
SELECTBOOLNOT(0),BOOLNOT(10),BOOLNOT(-3.79),BOOLNOT(NULL);+------------+-------------+----------------+---------------+| BOOLNOT(0) | BOOLNOT(10) | BOOLNOT(-3.79) | BOOLNOT(NULL) ||------------+-------------+----------------+---------------|| True | False | False | NULL |+------------+-------------+----------------+---------------+
Copy