• Hey David,

    Nice article, I think you'll find the advantage with EXCEPT when you have to compare multiple columns with possible null values on both sides. When you compare null values with a JOIN or a WHERE statement you will get a "wrong" result, when using the EXCEPT statement you will get the "right" result.

    see also:http://en.wikipedia.org/wiki/Null_(SQL)#Grouping_and_sorting

    Kim