>< SNIP >
>Nadya,
>
>I think you should write FAQ 'How to delete duplicate records'. Include all four ideas: Message #565099, Message #565029, Message #565097 and Message #565101 with explanation of there Pros and Cons.

Ok, I'll do. BTW, another method would be:

select distinct * from originaltable into myNewTable
delete originalTable
rename file NewTable to OriginalTable, if we're talking about free tables
or zap original and append.

However, I believe, the algorithm, I finally described with your corrections is the optimum here.