BIT_AND function [Aggregate]

BIT_AND function [Aggregate]

Returns the bit-wise AND of the specified expression for each group of rows.

Syntax

BIT_AND( bit-expression )

Parameters

Returns

See also

Standards and compatibility

Example

The following example generates four rows containing a CHAR column, then converts the values to VARBIT.

SELECT BIT_AND( CAST(row_value AS VARBIT) ) 
FROM dbo.sa_split_list('0001,0111,0100,0011')

The result 0000 is determined as follows:

A bitwise AND is performed between row 1 (0001) and row 2 (0111), resulting in 0001 (both values had a 1 in the fourth bit).
A bitwise AND is performed between the result from the previous comparison (0001) and row 3 (0100), resulting in 0000 (neither value had a 1 in the same bit).
A bitwise AND is performed between the result from the previous comparison (0000) and row 4 (0011), resulting in 0000 (neither value had a 1 in the same bit).

Discuss this page in DocCommentXchange.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1