>>>Can you post your statement, so I can help?
>>>
>>>BTW, I mistyped. It's Object_ID. My son who was standing near by told me, but I already switched to my gmail and didn't re-check as usual my message.
>>
>>You were so eager to get your stars that you didn't have to read my message :). My SQL Select is very long and I am not sure how it would help. This statement works very well against VFP data but now I am testing it against SQL Server and get this error. I am thinking that maybe SQL Server wants the statement to have ORDER BY first and then GROUP BY. I will test it now.
>
>Dmitry,
>
>As I said, don't use the field alias in your group by, use the actual field name. The GROUP BY should come before ORDER BY but let me double check to be sure.
>
>This works
>
>select FirstName as fna, LastName as las from AdminInfo group by FirstName, LastName ORDER BY FirstName

Thank you, Naomi. It works now.