On the contrary, Khubaib. The "Select DISTINCT" gets one only of each duplicated record, into the cursor. Have you actually tried it? OIn fact, I've just thought that the cursor isn't needed, As you've zapped the recipient table you could just select (SQL) the records straight into
that - One command.
>thanks terry for your reply,
>i do not want duplicate records i thing in this way all fields rcords replaced
>khubaib
- 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.