BITNOT

Description

Used to perform a bitwise inversion operation on an integer.

Integer range: TINYINT, SMALLINT, INT, BIGINT, LARGEINT

Syntax

BITNOT( <x>)

Parameters

parameter	description
<x>	Integer operations

Return Value

Returns the result of the NOT operation of one integer.

Examples

select BITNOT(7), BITNOT(-127);

+-------+----------+
| (~ 7) | (~ -127) |
+-------+----------+
|    -8 |      126 |
+-------+----------+