SET_BITS( expression ) 

LONG VARBIT

Rows where the specified values are NULL are ignored.

If there are no rows, NULL is returned.

The length of the result is the largest position that was set to 1.

The SET_BITS function is equivalent to, but faster than, the following statement:

SELECT BIT_OR( SET_BIT( expression ) ) 
FROM table;

• Bitwise operators
• GET_BIT function [Bit array]
• SET_BIT function [Bit array]
• sa_get_bits system procedure

The following statements return a bit array with the 2nd, 5th, and 10th bits set to 1 (or 0100100001):

CREATE TABLE t( r INTEGER ); 
INSERT INTO t values( 2 ); 
INSERT INTO t values( 5 ); 
INSERT INTO t values(10 ); 
SELECT SET_BITS( r ) FROM t;