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

>>
>>The problem with the code is the "a." preceding the ssn.
>>I believe as long as temp is in area "a" it will work.
>
>Dan,
>
>There's no 'a.' or ssn in either of above queries.

Good, you're back.
Someone to talk to.
:)

I think the problem is that the ssn is a memo.
Then I get this error.
Make Home_Phone a memo in the above code and try again.

Dan