Subject Re: [ib-support] where + logic and
Author Martijn Tonies

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

Upscene Productions

"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