BITXOR function

The BITXOR numeric function performs a bitwise XOR on the binary representation of two or more numbers.

Syntax

Read syntax diagramSkip visual syntax diagramBITXOR (source_integer,,source_integer)

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