! (bang sign) operator

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the logical NOT of a Boolean expression.

Syntax 

!expr

Arguments

  • expr: A BOOLEAN expression.

Returns

A BOOLEAN.

This operator is a synonym for not operator.

Examples 

> SELECT !true;
 false
> SELECT !false;
 true
> SELECT !NULL;
 NULL