"VALUE" or "value"
"VALUE" or "Value" or "vAlUe", etc.
?lcReplace="Test" lcExpression="This is a test TEST" ? Strtran(Strtran(lcExpression, Lower(lcReplace), lcReplace), Upper(lcReplace), lcReplace)You could use a VB object to do this.
Function StrTranC(ByVal cExpression As String, _ ByVal cFind As String, _ ByVal cReplace As String) As String StrTranC = Replace(cExpression, cFind, cReplace, , , vbTextCompare) End FunctionIn VFP, call it like this:
ox=CreateObject("VBStuff.VBFunctions") ? ox.StrTranC("This is a tEsT", "test", "Test")