What about ?anothertable.anotherfield_ ? Does it work?
It seems that "anotherfield_" is a field capture (having length more than 10); try the real field name instead.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>your question below >>>>>>>>>>>>>>>>>>>>>>>
hello everyone,

I'm trying to do the following :


lnMymonth = MONTH(date())
REPLACE myfield WITH anothertable.anotherfield_+ALLTRIM(STR(lnMyMonth))


I keep getting an error that says 'anotherfield_' variable is not found.


can this be accomplished.

Thanks,

Sergio