>>
>>To SQL server it's valid. IOW with a sample from pubs:
>>
>>
>>select distinct au_fname,au_lname, phone, right(phone,4) as PhoneNo
>> from Authors
>> order by PhoneNo,Phone
>>
>is valid.
>
>Cetin,
>
>What bug are you talking about? Such query works fine in VFP9.
>OPEN DATABASE (HOME(2) + "Data\testdata")
>USE testdata!employee
>SELECT DISTINCT first_name, last_name, ;
> home_phone, RIGHT(ALLTRIM(home_phone),4) AS ph ;
> FROM employee ;
> ORDER BY ph, home_phone
>
Sergey,
I didn't install VFP9 yet and cannot talk about a bug on my own. It was reported in this thread (provided a. was a typo) such a query returned "ORDER BY clause is invalid" error. I assumed it really returned that error in VFP9. If it doesn't than no problem. Otherwise it's a bug.
Cetin