BITWISEXOR

BITWISEXOR is a function that takes one or more integer parameters and returns the result of performing a bitwise XOR operation on all of them.

A bitwise XOR operation, also known as "exclusive OR", involves comparing the bits in the binary representation of two numbers and keeping the bits that are different. For example, if we perform a bitwise XOR operation on the numbers 5 (binary 101) and 3 (binary 011), we get 6 (binary 110), since the leftmost and rightmost bits are different in the two numbers.

Syntax

int BITWISEXOR(params int[] values)

Example

BITWISEXOR(5,3)

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:

BITWISEXOR(MyIntegers)