Sory, Sergey, you're right. I thought maybe Fabio would come up with a one-liner in SQL, so when I saw his message, I did not notice that it was regular Fox code, and not SQL.
>Hi Tore,
>
>Where is SQL in that code? The REPLACE is not SQL command.
>
>>It's not magic code, it's SQL. If you spend a day or two, and try to learn SQL, you will save a looot of time and code lines.
>>
>>>hi,
>>>thank you so much, also it work,
>>>but this is what i can call it magic gode.
>>>
>>>regards.
>
>>>>this is not perfect but can work:
>>>>
>>>>USE tty in 0
>>>>USE sss in 0
>>>>
>>>>replace IN sss ;
>>>> FOR tel==LOOKUP(tty.tel,tel,tty.tel) AND NOT EOF('tty') ;
>>>> Typ with tty.Typ
>>>>