Hi all,

Interesting questions...also the following query:

SELECT id

FROM dbo.SalesDates s

WHERE '2012/1/03' IN (SELECT saledate FROM SalesDates);

is equivalent to the one given in the QotD. If you try for the example dates, it produces the same results as with ANY and SOME.

(http://msdn.microsoft.com/en-us/library/ms177682.aspx)