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.