XOR Logical Operator - Select by Attributes

SteveFloyd

Is it possible to add the logical operator XOR to the Select By Attributes operators?  

For example, I may want to select street centerlines with a particular attribute on the left or right side, but I do not want the records where that attribute is on both sides.  It is possible to construct a selection query that functions as an XOR selection, and the following string shows how we select the Left XOR Right VTD (voting tabulation district) of a centerline.

(L_VTD = '127' AND R_VTD <> '127') OR ( L_VTD <>  '127' AND R_VTD = '127')

It would be so much less cumbersome to have a native operator for an XOR selection.
Thank you.

curtvprice

Let me generalize your expression

<SPAN class="comment token"># A XOR B</SPAN>
<SPAN class="punctuation token">(</SPAN>A <SPAN class="operator token">AND</SPAN> <SPAN class="operator token">NOT</SPAN><SPAN class="punctuation token">(</SPAN>B<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">OR</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">NOT</SPAN><SPAN class="punctuation token">(</SPAN>A<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">AND</SPAN> B<SPAN class="punctuation token">)</SPAN>‍‍‍
<SPAN class="comment token"># this should work too with one less NOT</SPAN>
<SPAN class="punctuation token">(</SPAN>A <SPAN class="operator token">OR</SPAN> B<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">AND</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">NOT</SPAN> <SPAN class="punctuation token">(</SPAN>A <SPAN class="operator token">AND</SPAN> B<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>