Hugo Kornelis (5/3/2010)

---

Using ISNULL can work around this - although the result is admittedly not trivial to understand:

AND NULLIF(Column1, Column2) IS NULL

AND NULLIF(Column2, Column1) IS NULL