>>
>>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,
Here you say it works but I found another message from you: Message #999392
Why should sales1 exist in base table? It's a bug, no?
Cetin