I have a situation where I have a string with two words in it that are all upper case that I'm running in a query. I want to convert the first word to Proper Case but leave the Acronym as all caps.
For example, I have the Term "ALCOSTA SCC" but it should be "Alcosta SCC". I also have other...