j-1064772 (1/13/2014)
Now THIS was the exact answer I was looking for.The article you referred to did not really go much beyond what I started with.
Thanks a million for drawing my attention to the issue of a NULL - I had not seen it coming.
Super !
INTERSECT and EXCEPT (and, IIRC, UNION and UNION ALL) all treat NULLs as NULL = NULL, as well.
--Jeff Moden
Change is inevitable... Change for the better is not.