At 11:09 PM 30/05/2004 +0000, you wrote:

>Can someone tell me what the bitwise AND and OR operators are?
>
>I have a bunch of binary flags stored in an integer field and I need
>to select only those where a certain flag is "on"...
>
>In MS SQL Server it was "&" and "|" and I changed the pipe to two
>pipes (||) and that appeard to work... but when I tried to change the
>ampersand to two ampersands (&&) FireBird did not appear to like
>that...

They are not supported internally. Use the external functions bin_and and
bin_or in ib_udf.

/heLen