>I need to make a mass replace of one word to another word but I want to preserve the case.
>
>Example I want to change TheOldWord to TheNewWord. But if the theoldword is this way then it needs to be thenewword or if is TheOLDWord it needs to be TheNEWWord or THEOLDWORD to THENEWWORD. I don't know all the cases that it might be in.
>
>I was hoping to not have to use ATC to find the word then loop checking the case with isupper and islower functions.
Check the last parameter of the STRTRAN function:
? STRTRAN("My THEOLDWORD is all upper", "TheOldWord", "TheNewWord",1,-1,1+2)
? STRTRAN("My theoldword is all lower", "TheOldWord", "TheNewWord",1,-1,1+2)
? STRTRAN("My TheOldWord is cammel case", "TheOldWord", "TheNewWord",1,-1,1+2)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.