>>>>
>>>>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).
--sb--