Bit logic in SQL - is it possible?

Have a long int field that I want to test if individual bits are set i.e

SELECT farm_code from nvz_visits_history where farm_type and 5;

Doesn't like it - is it possible to do?

Thanks

Adrian Harrison Received on Wed Jun 07 2000 - 00:00:00 CDT