I have data all in uppercase and I need to convert mixed case. For example:
1. I need the first letter to be Caps followed by all lower case the field is a PIC X(35). See example below:
INPUT: REINVEST DIVIDEND EXCHANGE
CHANGE IT TO: Reinvest dividend exchange
2. I need the first letter of every work to be Caps followed by lower case the field is a Pic x(45). See example below:
INPUT: NEW YORK STATE NATIONAL BANK
CHANGE IT TO: New York State National Bank
Thanks!
Your help is greatly appreciated [sig][/sig]
1. I need the first letter to be Caps followed by all lower case the field is a PIC X(35). See example below:
INPUT: REINVEST DIVIDEND EXCHANGE
CHANGE IT TO: Reinvest dividend exchange
2. I need the first letter of every work to be Caps followed by lower case the field is a Pic x(45). See example below:
INPUT: NEW YORK STATE NATIONAL BANK
CHANGE IT TO: New York State National Bank
Thanks!
Your help is greatly appreciated [sig][/sig]