O
Osvaldo Luis Aveni
Guest
Hello, I'm needing to do a query in a database through VB.NET. I have a table with a column named ColumnA and I want to have all the registers in wich the 4th bit was "1". I want to use the operation AND.
This is part of the code
strSQL = "SELECT * FROM Table WHERE ((ColumnA & 8) = 8)"
My intention is to get all the registers with the 4th bit of the field ColumnA = 1
It doesn't work. Could you please tell me how I can do this?
Thanks a lot
Continue reading...
This is part of the code
strSQL = "SELECT * FROM Table WHERE ((ColumnA & 8) = 8)"
My intention is to get all the registers with the 4th bit of the field ColumnA = 1
It doesn't work. Could you please tell me how I can do this?
Thanks a lot
Continue reading...