SQL bit query

[emueth]

I have a Cold Fusion application with a SQL 7 database. The database has an employee table with a bit field for storing certain permissions. How do I write my sql statement to, for example, return all employees that meet the criteria of a bitand on the fourth bit? Thanks in advance for the help.

 

[tlbroadbent]

I assume you mean BINARY data type rather than BIT. A BIT data type in SL Server hold one BIT, allowing values of 0 or 1.

Take a look in SQL BOL for Bitwise operators.

& (Bitwise AND)
Performs a bitwise logical AND operation between two integer values.

NOTE: Bitwise operators have integer arguments so you'll need to convert your Binary column to Integer for the operation.

cast(colA as int) & 4

I hope I understood your question and this information at least gets you started.

BTW: You can access SQL BOL from the following link.

http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin