~ (logical not)

The logical not operator (~) returns the logical negation of the argument.

Syntax

~X

Input

Argument Type Description
X
  • integer
  • big integer
 A scalar expression or column expression that evaluates to 0 or 1

Return Value

Returns a boolean value of 1 or 0 corresponding to the negation of X.

If X is 1, the result is 0. If X is 0, the result is 1.

The data type of the result is integer.

If X is N/A, the row is not displayed.