Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

BIT_AND function [Aggregate]

Takes n bit arrays and returns a bitwise AND-ing of its arguments using the following logic: for each bit compared, if all bits are 1, return 1; otherwise, return 0.

BIT_AND( bit-expression )

expression    The expression for which the value is to be determined. This is commonly a column name.

• BIT_OR function [Aggregate]
• BIT_XOR function [Aggregate]
• Bitwise operators

• SQL/2003    Vendor extension.

Suppose you have the following table, t, containing a single column, a, which is a VARBIT data type.

You want to know the AND value for the column. You enter the following SELECT statement, which returns 0000:

SELECT BIT_AND( a ) FROM t;

This result is determined as follows:

1. Row 1 (0001) is compared with Row 2 (0111), and results in 0001 (both values had a 1 in the fourth bit).

2. The result from the previous comparison (0001) is compared with Row 3 (0100), and results in 0000 (neither value had a 1 in the same bit).

3. The result from the previous comparison (0000) is compared with Row 4 (0011), and results in 0000 (neither value had a 1 in the same bit).