how to select with where on bits

[yglodt]

Hello,

I have in a DB a numeric field, that stores
a value which represents 8 bits.
(eg 9 means bit 1 and bit 4 are set)

Now I want to select all the records that have bit 4 set.

How can I do this ?

thanx,

yves

[the_Igel]

mysql bit functions , if you're about MySql.

for example, (my_int & 16) is true, when bit 4 is set.

[yglodt]

the previous post does work with mysql,
but not with IB 🙁