Bitwise AND (like mssql server &)

[Ruben Tieland]

Hi,

What is the syntax in access for the bitwise and operator like mssql server uses the "&" tag.

the syntax of my query in mssql looks something like this:
select (a.myint & b.anotherint) as BitwiseAnd from a, b where b.Aid = A.id
What would it be in access

I am using the Microsoft Jet Provider in my .ASP page to execute the query.

thanks in advance,
ruben

 

[Allen Browne]

The operator is BAND.

Works only with JET 4 (Access 2000 and later), and ADO.

 

[Ruben Tieland]

Thanks works perfect!