BITAND function

The BITAND numeric function performs a bitwise AND on the binary representation of two or more numbers.

Syntax

Read syntax diagramSkip visual syntax diagramBITAND (source_integer,,source_integer)

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.

For example: 
BITAND(12, 7)
returns 4 as shown by this worked example: 
   Binary Decimal
    1100    12
AND 0111     7
_________
    0100     4