& (Bitwise AND) (TSQL Operator)

Returns the bitwise AND value of two integers.

Syntax

expression & expression

Arguments

expression

is a numeric expression of type bit, tinyint, smallint, int, bigint.

Return Types

Returns the datatype of the expression with the highest type precedence.

Examples

-- binary representation of 143 is        10001111
-- binary representation of  95 is        01011111
-- binary representation of 143 & 95 is   00001111 (15)

PRINT 143 & 95;

The result is:

15