>Can someone help me with the syntax with REPLACE.
>
>REPLACE mytable.myfield with cSomething

Replace will not work if the current table is other than mytable and the current table is on the eof. This is why "in mytable" is STRONG. "mytable" in front of the field is also STRONG because it avoids errors in case you have fields with same names in more dbfs. Don't forget, even if you don't have it know, you may have it in the future.

INSERT SQL is faster than APPEND BLANK + REPLACE (or GATHER). And it's more reliable for RI.

Vlad