>>select distinct au_fname,au_lname, phone, right(phone,4) as PhoneNo >> from Authors >> order by PhoneNo,Phone >>>is valid.
>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,