>How can I know if the memo field has "abc" in it (may not be on first line). I do not know the code syntax to ask if one string contains another.
>
>
>>Replace all expr with strtran(expr, "alias.fieldname","fieldname")
>>or
>>Replace all expr with strtran(expr, "alias.","") && don't forget the dot
>
>>Just take care to do it for the alias of the current workarea, not the lookups.
>
>>>2)also want to edit the cursor path in the dataenvironment.
>
>>Didn't try that, but you may use a similar trick.
You can simply open your .frx and browse it, while keeping the expr memo open in a separate window, and see what you got there. Basically, you'd want to remove the alias of the table/cursor which will be selected while running the report, which usually means the things in the detail band and some things in groups, variables... Note that .frx stores them as lowercase (probably, I'm not quite sure).
Nevertheless, StrTran() will replace all occurences of "alias." (or whatever your alias may be), so if you mistype it, it won't find it and you've done nothing - no good, but no damage either. Browse first and see what you have.