thank you,it works
but i need to replace my field typ with 1 where records is duplicated
at mytable. or insert all duplicated records to newtable.
>Sorry, it was a type
>Select tty.telno from tty group by tty.telno having count(*)>1
>
>>hi,
>>thank you for reply,
>>error message SQL: HAVING clause is invalid
>>
>>
>>>>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(*)