Re: Bit logic in SQL - is it possible?

There is bitand function:

v734> select bitand(5,3) from dual;

B
-
1

--
Have a nice day
Michel


Adrian Harrison <a_harrison_uk_at_yahoo.co.uk> a écrit dans le message :
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

>