BITWISECOMPLEMENT

BITWISECOMPLEMENT returns the Bitwise COMPLEMENT operator on two or more integers.

A bitwise complement operation, also known as "bitwise NOT", involves inverting all the bits in the binary representation of a number. For example, if we perform a bitwise complement operation on the number 5 (binary 101), we get -6 (binary 010), since all the bits in the binary representation have been inverted.

Syntax

int BITWISECOMPLEMENT(params int[] values)

Example

BITWISECOMPLEMENT(5)

Returns -6

You can swap the value in the above function for a column that contains an array of integers or single integer. E.g. If you had an array of integers contained in the column MyIntegers the function would look like:

BITWISECOMPLEMENT(MyIntegers)