>>>>>Can someone help me with the syntax with REPLACE.
>>>>>
>>>>>REPLACE mytable.myfield with cSomething
>>>>>or
>>>>>REPLACE mytable.myfield with cSomething in mytable
>>>>>or
>>>>>REPLACE mytable.myfield with cSomething in "mytable"
>>>>>
>>>>>Tks
>>>>>Mike
>>>>
>>>>Use transparent syntax:
>>>>Select mytable
>>>>Replace mytable.myfield with cSomething
>>>Hi Ed,
>>>Do you have to select the table if you reference the field with the table alias as in mytable.myfield?
>>>Mike
>>
>>Actually not! But writing one more line of code you get clear readable syntax.
>
>Slower also! :)
>
>Vlad
What is slower: writing the line or running the line?
Edward Pikman
Independent Consultant