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