Bitwise XOR

Combines integer operands using a bitwise exclusive OR operation.

Category: bitwise

SQL symbol: ^

Syntax

<left> ^ <right>

Parameters

• <left> — An integer value. Accepts integer.
• <right> — An integer value. Accepts integer.

Returns

integer

Examples

SELECT 12 ^ 10;

6

Signatures

• integer ^ integer → integer

Notes

^ is exclusive OR, not exponentiation - a habit worth checking when porting SQL from systems where it raises to a power.

See Also

• Bitwise AND &
• Bitwise OR |