>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