>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
>
You might want to look at using the VBScript.RegExp object from the WSH; it can operate in a case-insensitive fashion. See the WSH docs; George Tasker and I wrote a set of 5 articles for VFUG (
www.vfug.org) on the WSH, which included the RegExp object, and there are a ton of refs in the links in my sig block.