Bitwise Operators Transact-SQL

OperatorMeaning
&Bitwise AND
|Bitwise OR
^Bitwise exclusive OR