Re: Bit logic in SQL - is it possible?

There is a more or less hidden bitand function that addresses this

Hth,

Sybrand Bakker, Oracle DBA

Adrian Harrison <a_harrison_uk_at_yahoo.co.uk> schreef in berichtnieuws k9rsjscm4fvfjno53sg0s9bg279564r66f_at_4ax.com...
> 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