Extracting binary data from a numeric field

I am using VB 6.0
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 field's 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 used the bitwise operator and [&] like this:
"Select Id, IDate, [Status] from Invoices where ([Status] & 4) = 4"
This has retreived 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 SQL Statment 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!

Categories