BIT_OR function [Aggregate]

BIT_OR( bit-expression )

bit-expression The object to be aggregated. The expression can be a VARBIT array, a BINARY value, or an INTEGER (including all integer variants such as BIT and TINYINT).

The same data type as the argument. For each bit position compared, if any row has a 1 in the bit position, this function returns 1; otherwise, it returns 0.

SQL/2008 Vendor extension.

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

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

The result 0111 is determined as follows:

A bitwise OR is performed between row 1 (0001) and row 2 (0111), resulting in 0111.
A bitwise OR is performed between the result from the previous comparison (0111) and row 3 (0100), resulting in 0111.
A bitwise OR is performed between the result from the previous comparison (0111) and row 4 (0011), resulting in 0111.

BIT_OR function [Aggregate]

Syntax

Parameters

Returns

See also

Standards and compatibility

Example