SQL SELECT WHERE value is "Binary AND a paticular Binary number"?

[mdlueck]

I am storing various bit mask data as a Base 10 number in a table column.

With said value, I run a VBA Binary AND upon the stored number to determine if a particular bit is 1/0, thus I know the state of that attribute value.

Is there some way to have SQL Server select based on that same scenario... only select records where the stored value is true of "AND 8" as example? I would need returned all records where the 8 bit is true of the Base 10 number.

 

[tehNellie]

Not done it personally, but there's an article featuring a couple of functions to convert Binary to decimal and vice-versa: http://improve.dk/archive/2011/07/11/converting-between-base-2-10-and-16-in-t-sql.aspx

 

[mdlueck]

Thank you, tehNellie. I will submit my question to that blog post. There was no example of binary functions being used in a WHERE clause.

 

[mdlueck]

Per that blog post, apparently binary comparisons are possible in WHERE clauses:

http://improve.dk/archive/2011/07/1...n-t-sql.aspx#ctl13_CommentList_ctl02_NameLink