What you mean is delete the triplicate record of each triplet, or all but duplicate.
>Dear Experts,
>
>Table1 has three fields as
>
>date---------d(8)
>voucher-----n(4)
>type---------c(2)
>
>data in table is as follows
>
>25/11/06----1----SL
>25/11/06----1----SL
>25/11/06----2----SL
>25/11/06----2----SL
>25/11/06----2----SL
>25/11/06----1----SD
>25/11/06----1----SD
>25/11/06----1----SD
>
>I want to delete more than two records according to following index file
>
>select table1
>index on dtoc(date)+str(voucher)+allltrim(type) to xyz
>
>after processing the data in table should look like this
>
>25/11/06----1----SL
>25/11/06----1----SL
>25/11/06----2----SL
>25/11/06----2----SL
>25/11/06----1----SD
>25/11/06----1----SD
>
>The number of same records is two.
>
>Please help
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.