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

Testing numeric values with bitwise operators.

   <source lang="sql">

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>

</source>