Re: binary logic in SQL?

this code works :

select * from emp where bitand(flags ,2) = 2;

• teddy.

Rodney Volz wrote in message <76vsb0$j1i$1_at_news.LF.net>...
>Is there any way to use bitmap masks in oracle? What
>I need is something like:
>
> select * from emp where flags & 0x02 != 0;
>
>where "flags & 0x02" behaves as if it was C code.
>
>Thanks,
>-Rodney Volz
>
Received on Thu Jan 07 1999 - 17:11:57 CST