how to extract binary data from field value

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!