BITAND
Syntax
BITAND(<integer>;<integer>; ...)
Description
Bitwise AND operation on given integer arguments. The function converts the integers to binary and returns 1 in each bit position where all input arguments have a one in the corresponding position and zero in all others.
This function supports more than 255 arguments.
Examples
Column1 | Column2 | Column3 | BITAND() returns |
|---|---|---|---|
Example 1 | |||
2 | 3 | 6 | 2 |
(0010) | (0011) | (0110) | = 0010 |
Example 2 | |||
4 | 8 | 12 | 0 |
(0100) | (1000) | (1100) | = 0000 |
Example 3 | |||
23 | 8 | 109 | 5 |
(0010111) | (0111101) | (1101101) | = 0000101 |