In a string of words: How would I keep the first character of each word uppercase and lowercase the remaining letters of each word?

[profuse]

Hi,

I have a column that contains the mailing address in uppercase: 1234 MAIN WAY DRIVE.

In tMap how would I keep the first character of each word uppercase and lowercase the remaining letters of each word in the string to look like this: 1234 Main Way Drive

Thanks

[Stamen_Nikolov]

Thumbs Up, TRF! Nicely explained, short, accurate, working! Thank you!