Bitwise Operators
This page describes the available operators to assist with performing bitwise operations on numeric values.
~ NOT
~ is a unary operation that performs bitwise negation on each bit. Bits that
are 0 become 1, and those that are 1 become 0. Expects a value of long or
int type.
Examples
SELECT ~1024
| column |
|---|
| -1025 |
& AND
& is a binary operation that takes two equal-length binary representations and
performs the bitwise AND operation on each pair of the corresponding bits.
Expects values of long or int type.
Examples
SELECT 5 & 3
| column |
|---|
| 1 |
^ XOR
^ is a binary operation that takes two bit patterns of equal length and
performs the bitwise exclusive OR (XOR) operation on each pair of corresponding
bits. Expects a value of long or int type.
Examples
SELECT 5 ^ 3
| column |
|---|
| 6 |
| 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 or int type.
Examples
SELECT 5 | 3
| column |
|---|
| 7 |