& (Bitwise AND) (SQL Server Compact)

Performs a bitwise logical AND operation between two integer values.

Syntax

expression & expression

Arguments

  • expression
    Any valid expression in Microsoft SQL Server Compact of any of the data types of the integer data type category. The expression* *is an integer parameter that is treated and transformed into a binary number for the bitwise operation.

Result Types

Returns an int if the input values are int, a smallintif the input values are smallint, or a tinyint if the input values are tinyint.

Code Example

The following example performs the bitwise AND operation between two integer columns.

CREATE TABLE bitwise (A int NOT NULL, B int NOT NULL)
INSERT bitwise VALUES (170, 75)
SELECT A & B FROM bitwise
--Returns 10.

The binary representation of 170 (A) is 0000 0000 1010 1010. The binary representation of 75 (B) is 0000 0000 0100 1011. Performing the bitwise AND operation on these two values produces the binary result 0000 0000 0000 1010, which is decimal 10.

(A & B)
         0000 0000 1010 1010
         0000 0000 0100 1011
         -------------------
         0000 0000 0000 1010