doug.davidson (1/29/2015)
Brian Hibbert (1/29/2015)
Great question, and I nearly clicked 0 because '2014' = True SHOULD fail, but doesn't in SQL.So this is the real answer. Much better than the provided link in explaining why 8 was the correct answer.
Hey wait a second! Why DOES this work??? Because you're right. the documents state that SOME returns a true/false.
Correct??
So in SQL a constant compared to true will return true?
Or to put it another way, any WHERE statement like:
WHERE 'whatever' = a SOME statement that always returns a true result
will always return all rows?
Peter A.R. Johnson