Re: Bitwise Comparison in WHERE Clause

From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 12:50:28 +0100

> Can a bitwise comparison be made in the WHERE clause of a SELECT statement
using >ADO and the OLE DB Provided for Microsoft Jet? If so, can someone
provide a simple >example.

I can do bitwise comparisons for SQL Server. You might be able to do the
same for Jet, I do not know.

select count(flags) from track where (flags & 1) <> 0

That is a bitwise comparison. Only rows where the least significant bit set
are selected.

Stephen Howe