Noah Fields13,985 Points
"Except", not XOR?
I thought the term for finding all instances belong in Set A, and all instances which belong in Set B, but not any instances that belong to both A and B, was referred to as an Exclusive Or, or XOR for short. Here, it's referred to as an "except". Am I incorrect? Are there certain instances which one of the two terms is more accurate or correct? What difference, if any, is there between the meaning of the two terms?
Steven Parker203,121 Points
EXCEPT is not the same concept as XOR.
Both would return items from set A that are not in set B. But XOR would also return items from set B that are not in set A, where EXCEPT would not return any items from set B at all.
In set theory, this is called a "difference". The set theory equivalent of XOR is a "symmetric difference".