Ed,

Another SQL option to select all occurences of the dups based upon some criteria:

This example uses the zip and lastname but any "match code" could be substituted. In practice, I'd probably union a few of these with differen't criteria.

select * from TABLE ;
where left(zip,5)+upper(alltrim(lastname)) in ;
(select left(zip,5)+upper(alltrim(lastname));
from table;
group by 1;
having count(*)>1);
into cursor dups


HTH