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

Cetin-

I've run this code after creating a temp table with all these fields.
It only fails because of the "a." in front of the ssn.

But if you
Select A
Use Temp

Then issue the select it works fine.


Dan