I've had the following bit of code in play in one form or another since my Q&A days:
DIRECTIONS=@REPLACE(DIRECTIONS," west "," West ")
DIRECTIONS=@REPLACE(DIRECTIONS," east "," East ")
DIRECTIONS=@REPLACE(DIRECTIONS," north "," North ")
DIRECTIONS=@REPLACE(DIRECTIONS," south "," South ")
DIRECTIONS=@REPLACE(DIRECTIONS," main "," Main ")
DIRECTIONS=@REPLACE(DIRECTIONS," st "," St.")
My dispatcher pointed out to me an odd effect this was having that we've never noticed before. He was attempting to enter some directions to a Customer's location in the "Directions" field, and was using ALL CAPS because our drivers had not been paying attention. To his frustration, every time he entered "GO SOUTH ON RTE 1" the text was changing to "GO South ON RTE 1".
I did some experiments and it looks like my @REPLACE command is changing any version of the word " south ", be it all caps, all lower case, or mixed case, into " South ". Page 354 of the programming guide offers no help in regards capitalization. I was sure the double quotes defining the literal string " south " (including the spaces) would change only that LC version, but apparently not.
Any help would be appreciated.