COUNT_SET_BITS function [Bit array]

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

Syntax 
COUNT_SET_BITS( bit-expression )
Parameters

  • bit-expression   The bit array for which to determine the set bits.

Returns

UNSIGNED INT

Remarks

Returns NULL if bit-expression is NULL.

Standards and compatibility

  • SQL/2003   Vendor extension.

Example

The following statement returns the value 4:

SELECT COUNT_SET_BITS( '00110011' );

The following statement returns the value 12:

SELECT COUNT_SET_BITS( '0011001111111111' );
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1