>>>>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