The BITAND numeric function performs a bitwise AND on the binary representation of two or more numbers.
BITAND takes two or more integer values and returns the result of performing the bitwise AND on the binary representation of the numbers. The result is INTEGER unless either parameter is NULL, in which case the result is NULL.
BITAND(12, 7)returns 4 as shown by this worked example:
Binary Decimal 1100 12 AND 0111 7 _________ 0100 4