Something like this (it is not clear from your post what field is critical for duplicate records):

sele (dupfield) from phon0701 group by 1 having cnt(*) =2 into curs temp


>Hi:
> I have a table and that table contains duplicate records. I want to copy all the duplicate records to a temp. file.
>
>SELECT Phon0701.ani, Phon0701.billdate, Phon0701.duedate,;
> Phon0701.totlocchrg, Phon0701.entrydate, Phon0701.entryby;
> FROM phon0701;
> WHERE Phon0701.vendor = '12182' and deleted() = .F.;
> ORDER BY Phon0701.ani;
> InTo cursor CmnthlyRpt
>
>How can I copy dup. rec. to a temp file? I try using set order to anii, but this did not work.
>Thanks