is there a Strtran function (or similar) which will replace text but in a case insensitive manner, e,g,

Abc=Strtran(MyFruit,'Apples','Coca Cola')
Abc=Strtran(MyFruit,'apples','Coca Cola')......

otherwise I will need to put every possible combination of 'Apples' in using Upper and lower case

I am using Strtran on a memo field, so it is not possible just to upper it first

Regards,

Gerard