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>