bitnot(X;Y)

Returns the bitwise NOT operation on the specified least significant bits of a given 32-bit integer.

Syntax

bitnot(X;Y)

Input

Argument Type Description
X integer A scalar value or the name of a column

X must be a 32-bit integer (between -2147483646 and +2147483646).
Y integer A scalar value or the name of a column

Y should be an integer between 0 and 32.

Return Value

Returns an integer value corresponding to the bitwise NOT of X (i.e., X with its bits flipped) ANDed with (2Y)-1 (i.e., the Y-bit complement of X).

If X and/or Y is N/A, they are handled according to their internal representation like any other number.