>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

To locate the duplicates, you can use this code.

Select tty.telno from tty group by tty.telno having count(*)