BITWISE AND

I have a conversion task to perform. One of the fields contains a series of 1's and 0's ie: 10011011.                             

This field represents a number of flags that are turned on!

Now, I could store this field as a numeric column (in this case the value would be 155 as bitpos 1,4,5,7 and 8 are turned on.

How would I in SQL, determine which flags are turned on in a SELECT statement?

Something along the lines of a BITWISE AND operation. ie: To determine if flag number 4 is turned on I would AND the colums

    value with 4 and test the result is 4.

As far as I know, BITWISE ops are not possible in SQL. Received on Tue Feb 21 1995 - 11:52:08 CET