The following query takes the input argument 23, which has a data type of BYTEINT and a binary representation of 00010111. Because target_value_arg is not specified, the default value of 1 is used. Therefore, the function counts the number of bit values that are set to 1. The query result is an INTEGER value of 4.
SELECT COUNTSET(23);