>I have table with 5 or so fields and I am trying to eliminate records where there are duplicates based on the field UPIN. The whole record isn't duplicated but the UPIN value is. So the name,UPIN,credential would/could be duplicated but the zip,state, and specialty might be different. I need only unique (DISTINCT) records based on the UPIN field but I need the whole record.
>Hope this isn't clear as mud.
>Thanks,
>Eric

The following code will select one record per UPIN with data comming from the last record for each duplicate UPIN

SELECT * ;
  FROM mytable ;
  GROUP BY UPIN ;
  INTO CURSOR mycursor