XOR64(a,b) which takes exactly two parameters and converts them to 64 bit integers. It then returns the unsigned 64 bit XOR of those two values. If either value is NULL then the result is NULL. If there are more or less than two parameters, then an error is returned.

 

Example:

SELECT xor64('1234567890', '9876543210')

returns 8676316216

 

SELECT xor64('1234567890')

returns SYNTAX ERROR