Thank you.

Yes, the Test_BAND procedure works as you say. However if I copy the SQL and
paste it into an Access query, Access complains.

I found something about SQL Server somewhere that says that BITAND is the
equivalent of the "&" operator, but neither of those work for an Access
query. At least I was not able to get them to work; the "&" operator always
concatenated text values.

Access queries do seem to do their own thing.


"Van T. Dinh" wrote in message
...

"Table1" can be any Table with some Records. When tested, it worked
correctly giving me a column of 4 (i.e. bitwise op) in the Debug window.
If
I replace "BAND" with "AND" in the SQL String, I get a column of -1 (True,
i.e. logical op)!