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 |
+-------+----------+