Truth Table
& 0 1
0 0 0
1 0 1
Finding Out if the First Bit Is Turned On, Behind the Scenes
10101010 -- 170
&
00000001 -- 1
--------
00000000 -- 0
Finding Out if the Second Bit is Turned On, Using T-SQL
18> SELECT
19> 170 & 2
20> GO
-----------
2
(1 rows affected)