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