thank you very much ,


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