XOR

Description

Performs a bitwise exclusive OR operation on two BOOLEAN values.

Syntax

 <lhs> XOR <rhs>

Parameters

parameter	description
<lhs>	The first BOOLEAN value to be evaluated
<rhs>	The second BOOLEAN value to be evaluated

Return Value

Returns the exclusive OR of two BOOLEAN values.

Examples

select true XOR false,true XOR true;

+------------------+-----------------+
| xor(TRUE, FALSE) | xor(TRUE, TRUE) |
+------------------+-----------------+
|                1 |               0 |
+------------------+-----------------+