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. What I would like is something
like:

SELECT * FROM TABLE_NAME
WHERE (BIT_MASK AND 3)

That would return the line if BIT_MASK had bit 1 or 2 set.

WHen I process the field, I am just using a regular integer in Delphi.

I am using the latest EMS interbase/Firebird manager to test this out.

Is this possible?