I think it's because we're so used to typing "Select *..." or "Select fieldname..." that when we type "Select Top..." our brains think 'top' is a fieldname?

That's my story, I'm sticking to it.


>For some reason I often forget to specify the column list with TOP myself :)
>
>>Oh dwurp! (headdesking).
>>
>>I was so concerned with getting the expression right that I didn't even notice I'd forgotten that.
>>
>>Thanks Sergey
>>
>>>You forgot to enclose expression in parenthesizes and specify column list
>>>