Hi,

You need to use an UDF for this. IB comes with a set of
standard UDFs, one of them is BIT_AND(...) ...

Read the Language Reference, chapter User Defined Functions
on how to use them.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Hello,
>
> I have a (bit-based) integer field in my IB6 db, and e.g. I need to
> select
> 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