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

Doug,
this is a vfp9 bug, but VFPT "guru" say it is ok, then you have to use a workaround.

workaround 1 ( fast )

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

workaround 2 ( slow )

SELECT * FROM ;
(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 ) t_distinct;
  order by ssno, ssn;
  into cursor address