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(*)