Can any one explain the Use of Carat(^) symbol in SQL server

Question

HI  Can anyone explain the use of the ^ sybol with an example in Sql sever. Thanks in advance Ravi.

Sagar Pardeshi · Answer

Hello Ravi The caret (^) translates to the XOR operator which is a bitwise exclusive or. In plain english it means either but not both. Here's what it does: decimal 1 = binary 001 decimal 1 = binary 001 XOR XOR decimal 2 = binary 010 decimal 3 = binary 011 = = decimal 3 = binary 011 decimal 2 = binary 010 More info on the MSDN page for bitwise operations- https://docs.microsoft.com/en-us/sql/t-sql/language-elements/bitwise-operators-transact-sql .