XOR operator
538603Oct 17 2006 — edited Oct 17 2006Is there any way to use XOR operator in select?
For example I want to achieve smth like:
select * from MyTable where col1 ='A' XOR col2 = 'B' XOR col3 = 'C'
Any ideas how to make this? (I will be very happy if someone give me an example)
Thanks