>>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.
Sergey, I just looked up the SQL SET FMTONLY command as referenced in your earlier message. This would do the trick too.
Thanks for you help with this one. Its *much* appreciated.
Regards,
-=Gary