>
>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