Subject where + logic and

I have a (bit-based) integer field in my IB6 db, and e.g. I need to
all the fields that have bit 3 set.

In mysql I think you can do it with a where-clause like this:
where (X & 8) = 8

In IB it doesn't work, and I found nothing in the ibsqlref document.

How can I do this ?

thank you,

Yves Glodt