Help with a query

[Guy Cohen]

Hi all.
Lets say I have tblCompanies with
CompanyName (string)
Products (long)

How do I select the records that have a number in products that has BIT 0
and BIT 1 on.
Example:
If the table has:
C1, 0
C2, 19
C3, 77

The query should return only C2
19=10011

TIA
Guy

 

[Tonín]

SELECT *
FROM YourTable
WHERE ([Products] Mod 4)=3;


Tonín