>Hi Gang!
>
>I want to be able to find records in a table that have more than one field that is duplicate (last_name + first_name). We want to get rid of the duplicate fields (combine them together).
>
>So first, to find them....
>
>Is this code ok? To find all duplicate records on last_name + first_name ?
>
>

>SELECT last_name, first_name, alt_custno, paquinnumb FROM customer ;
>	WHERE last_name + " " + first_name IN ;
>		(SELECT last_name + " " + first_name AS cust_name FROM customer ;
>			GROUP BY last_name, first_name ;
>			HAVING count(last_name + " " + first_name) > 1);
>	ORDER BY last_name, first_name INTO CURSOR FINDDUPE
>
>

>
>Runs ok, but I want to be sure from others!
>
>Thanks!

The code is OK. You can also use a variation of it:

SELECT last_name, first_name, alt_custno, paquinnumb FROM customer ;
	inner join (select LastName, FirstName, count(*) as Dups from Customer group by LastName, FirstName having count(*) > 1) X
on Customer.LastName = X.LastName and Customer.FirstName = X.FirstName