Time to sharpen the MODs pencil?
http://forums.sqlteam.com/t/conditional-where-clause-based-on-bit-value/2713/13