>hi all,
>
>i try as under to finde the duplicted records, not works any idea
>thanks
>
>CLOSE all
>USE tty in 0
>m.telno=telno
>INDEX on telno TO gg
>
>SCAN FOR telno==m.telno
> IF FOUND()
> replace typ WITH 1
> ENDIF
>ENDSCAN
>brow
>
>
>
>thanks
Please just check
Eliminating duplicates in a table FAQ #8129 It should give you ideas.
If it's not broken, fix it until it is.
My Blog