>>>This used to work fine in vfp3
>>>

>>>select distinct last_name, first_name, mid_name, ;
>>>  address1, address2, city, state, zip_code, ;
>>>  ' ' as packet_id,ssn, right(a.ssn,4) as ssno ;
>>>  from temp ;
>>>  into cursor address ;
>>>  order by ssno, ssn
>>>

>>>How to fix in vfp9 besides making two statements?
>>>How to find all like this in code?
>>
>>select ... order by 11,10
>>
>>should work. Does it?
>>PS: There is a potential error in code there - right(a.ssn,4).
>>Cetin
>
>Actually, I get this error if SSN is a memo.
>To correct the error you have to make sure you don't include
>the memo field in the order by.
>SSN is creating the problem not ssno.

If it's a memo I still don't expect the error (expect but not that one). IOW this should work:

select distinct right(notes,4) as myOrder from employee order by myOrder

Cetin