Re: Does derby support bitwise operators in SQL?

[Dan Karp]

> I'd like to know if Derby supports bitwise operators in SQL
> statements. 

Nope.  Wish it did, but nope.

> select *
> from MyTable
> where (status & 5) = 5

One workaround is:

SELECT * FROM mytable
WHERE MOD(status, 2) = 1 AND MOD(status / 4, 2) = 1;