I have a varchar() column that holds text with embedded spaces in upper case (eg OLD HALL STREET). I need to convert this text to initcap() (eg Old Hall Street). There may be any number of spaces in the text, the next letter after each space being upper case.
Has anyone got a function ready built to do this?
Thanks in anticipation