I have a situation where I am using STRTRAN to replace some text in a memo field. It goes like this:
REPLACE mymemo WITH STRTRAN(mymemo,'my text','new text')
But, sometimes, in the memo field, the text that need to replaced is either lower case, upper case or a mix of both.
If I use something like this:
REPLACE mymemo WITH STRTRAN(UPPER(mymemo),'MY TEXT','new text')
it will replace all the variations of my text but will also replace the memo field in uppercase. How, can I get all the variations by keeping the memo field as is?