You nearly made me choke on my coffee! :-)

>Then you must add some more code....
>
>>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(*)