>>>It goes into EXPR field in .FRX. Yes, you need to know OBJTYPE and for the report field
>>>OBJTYPE = 8
>>Hi Nick:
>>ok - it works, but I do not want to replace the whole expression.
>>my expressoion is MYTABLE.MYFLDNAME. I just want to replace MYTABLE with NEWTABLE. I tried the following...REPLACE ALL substr(EXPR,1,7) WITH "NEWTABLE" FOR objtype = 8...it does not like the substr(EXPR,1,8)...any ideas?
>
>REPLACE ALL EXPR WITH STRTRAN(EXPR, "MYTABLE", "NEWTABLE") FOR objtype = 8

You cannot put the expression like SUBSTR(EXPR,1,7) instead of a field name in REPLACE command.