Re: [sqlite] bit operations in select statements

select key where value & '01011'; Try: select key where (value&176) you need to convert the bit string to an integer number. Also be aware that sqlite interperts numbers as signed 64 bit integer and this can cause some issues with your bit mask number. HTH. Jos van

Re: [sqlite] bit operations in select statements

Am 20.02.2008 um 11:54 schrieb Jos van den Oever: > Hi all, > > Is it possible to use logic operations on fields, in particular on > integers and on fixed sized blobs (256 bits/32 bytes). > I'd like to do queries like this: > select key where number_of_bits_set(value) = 10; I believe for this

[sqlite] bit operations in select statements

Hi all, Is it possible to use logic operations on fields, in particular on integers and on fixed sized blobs (256 bits/32 bytes). I'd like to do queries like this: select key where number_of_bits_set(value) = 10; or select key where value & '01011'; What would be a good method of