Extracting binary Data from numeric Field

I am using a field called [Status] to store binary data in it, i.e. 1,2,4,8,16,32,64,128 and so on
and then I need to check if a binay value is included with that fields value, i.e. if the field value = 14, then it should contain the binary values 2,4, and 8
I have done this with MS SQL Server and use the bitwise and [&]
"Select Id, IDate, [Status] from Invoices where ([Status] & 4) = 4"
This will retreive all the records that has the field [Status] containing the [4] value in it, that is any record with the [Status] field value = 4 or 5 or 12, or 14 and so on
but I need a similar to it in ADO or Access
Thank you so much
Gameel Al-Einei
Cairo, Egypt

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!