BITXOR function
The BITXOR numeric function performs a bitwise XOR on the binary representation of two or more numbers.
Syntax
BITXOR takes two or more integer values and returns the result of performing the bitwise XOR on the binary representation of the numbers. The result is INTEGER unless either parameter is NULL, in which case the result is NULL.
For example:
BITXOR(12, 7)
returns 11
,
as shown by this worked example: Binary Decimal
1100 12
XOR 0111 7
_________
1011 11