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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

COUNT function [Aggregate] Next Page

COUNT_SET_BITS function [Bit array]

Returns a count of the number of bits set to 1 (TRUE) in the array.


COUNT_SET_BITS( bit-expression )


The bit array for which to determine the set bits.


Returns NULL if bit-expression is NULL.

Standards and compatibility

SQL/2003    Vendor extension.


The following statement returns the value 4:

SELECT COUNT_SET_BITS( '00110011' );

The following statement returns the value 12:

SELECT COUNT_SET_BITS( '0011001111111111' );