>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.