BITAND()

Scalar. Returns the results of performing a bitwise AND operation on two expressions.

Syntax

BITAND( expression1, expression2 )

Data Types
Return	expression1	expression2
Integer	Integer	Integer
Long	Long	Long

INSERT INTO OutStream
SELECT BITAND(InStream.IntColumn, 1010)
FROM InStream;