alan davies wrote:

> Can anyone help with removing a lot of duplicate records that have been
> imported from an external system.

Create some temporary table with same structure, and do

insert into temporary_table
select distinct col1, col2, col3, ...etc
from table_with_duplicates;

Then just empty the original table, and import the records back:

delete from table_with_duplicates;

insert into table_with_duplicates
select * from temporary_table;

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net