>>>>>
>>>>>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,
>
>DISTINCT cannot be used with Memo fields. It's documented change in VFP8 (SET ENGINEBEHAVIOR 80).
Yes, I saw the same thing.
But the first error you will get is "Order by clause is invalid".