This page describes the available operators to assist with performing bitwise operations on numeric values.

Precedence of these operators is as follows:

1. ~ NOT
2. & AND
3. ^ XOR
4. | OR

~ NOT

~ is a unary operation that performs logical negation on each bit. Bits that are 0 become 1, and those that are 1 become 0. Expects a value of long type.

Examples:

SELECT ~1024

& AND

& is a binary operation that takes two equal-length binary representations and performs the logical AND operation on each pair of the corresponding bits. Expects values of long type.

Examples:

SELECT 5 & 3

^ XOR

^ is a binary operation that takes two bit patterns of equal length and performs the logical exclusive OR operation on each pair of corresponding bits. Expects a value of long type.

Examples:

SELECT 5 ^ 3

| OR

| is a binary operation that takes two bit patterns of equal length and performs the logical inclusive OR operation on each pair of corresponding bits. Expects a value of long type.

Examples:

SELECT 5 ^ 3