it deleted ones that do not have duplicates. i would like to keep any records that do not have duplicates.

brenda


>select keyid, lastname+firstname customer, count(lastname+firstname), max(add_date) from mytable group by 2 having count(lastname+firstname) > 1 into cursor crsTemp

>delete from mytable where lastname+firstname in (select customer from crsTemp) and keyid not in (select keyid from crsTemp)