Using bitmasks with OData

Feb 12, 2013 at 3:52 PM
It is probably not the best place to ask this question but I couldn't find any OData specific forum.

In our project we use one field to store flags where a first bit is for read/unread flag and another one is private/public. So using SQL syntax I could do combinations like this:
SELECT * FROM records WHERE flags & 1 AND flags & 2 = 0 to get results where records are read and private.

I looked through the OData documentation and I didn't find any way to work with bitmasks. Is there any way to do that using OData syntax without creating custom functions on the server side?