Ann W. Harrison wrote:

>mobiltexmark wrote:
>
>
>>I have a field that defines a bitmask and would like to have the sql
>>search return data based on the mask, but can not seem to find
>>anywhere describing bit operations.
>>
>>
>
>Firebird doesn't support bit operations directly. You can probably find
>a UDF that provides that support but you'll be giving up all indexed
>optimization.
>
>

ib_udf (which seems to be part of the firebird-distribution) provides
such functions:
bin_and, bin_or, bin_xor

I've already used them successfully :)

--
Magnus