BITNOT()

Scalar. Returns the value of an expression with all bits inverted (zeroes set to one and vice-versa).

Syntax

BITNOT( expression )

Data Types
Return	expression
Integer	Integer
Long	Long

INSERT INTO OutStream
SELECT BITNOT(InStream.IntColumn) AS Negated
FROM InStream;