>Right, James indicated that he had heard this was the case and as usual, you have confirmed it :)
>
>If you have the time, could you tell me what the SQL optimization does in this case? For example, does it decide that "1 = 2" is inherently FALSE and therefore it doesn't interogate the table other than to return the schema metadata for the empty result set? Just keen to understand what SQL optimization is as opposed to our own Rushmore style optimization.
Yes, you're correct.
--sb--