! (bang sign) operator

Applies to: Databricks SQL Databricks Runtime

Returns the logical NOT of a Boolean expression. This operator is a synonym for not operator.

!expr

• expr: A BOOLEAN expression.

A BOOLEAN.

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

• and predicate
• or operator
• not operator