not operator

Applies to: Databricks SQL Databricks Runtime

Returns logical negation of the argument.

Syntax

not expr

Arguments

• expr: A BOOLEAN expression.

Returns

A BOOLEAN.

This operator is an alias for ! (bang sign) operator.

Examples

> SELECT not true;
 false
> SELECT not false;
 true
> SELECT  not NULL;
 NULL

Related functions

• & (ampersand sign) operator

• | (pipe sign) operator

• ! (bang sign) operator