Hello, bit_count(bit_or(1<<table1.sid))
can i use this on a field char(32)? i tried bit_count(bit_or(256<<table1.sid)) but it doesn't seem to work. (cause i thought 32byte is 8x32 bits) Best regards, Bas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]