SQL Server/T-SQL/Select Query/Bitwise Operator

Testing numeric values with bitwise operators.

 
6>
7>     CREATE PROC pr_bitwise
8>     AS
9>     DECLARE @chvHold INTEGER
10>     SELECT @chvHold = 2
11>     IF ( @chvHold & 1) = 1
12>          BEGIN
13>             PRINT "One Selected"
14>             RETURN
15>          END
16>     IF ( @chvHold & 2) = 2
17>          BEGIN
18>             PRINT "Two Selected"
19>             RETURN
20>          END
21>     IF ( @chvHold & 3) = 3
22>          BEGIN
23>             PRINT "Three Selected"
24>             RETURN
25>          END
26>     IF ( @chvHold & 4) = 4
27>          BEGIN
28>             PRINT "Four Selected"
29>             RETURN
30>          END
31>     GO
1>
2>     EXEC pr_bitwise
3>     GO
Two Selected
1>
2>     DROP PROC pr_bitwise
3>     GO
1>