Upper to Lower Case 1

[szaunbr]

Hello,

I am using CR9 and an Informix DB. I have a field that is all uppercase and I would like to change it to lower case.

There is one problem with this, the field has multiple words in it and I want to keep the first letter of each word capitalized.

EX: ANYWHERE HIGH SCHOOL to be change to:

Anywhere High School

Any help will be appreciated. Thank you.

 

[Kendel]

You can use ProperCase().

 

[szaunbr]

Wow, that was easy. Thanks a million.