Unanswered: SQL bitwise comparisons using DAO, .mdb
Using VB6(SP5), DAO, .mdb
I'm trying to use SQL to return records based on the AND bitwise operator which should be the (&) character, however there is no MS documentation that i could find. My Where clause query seems to recognize the (&) character, but 0 records, or all records are returned, and i had bits set in only 3 records(of course verified). I have tried many SQL Where clause formats without luck.
Can this be accomplished, or did MS drop the ball again?