Originally Posted by Stealth_DBA
Donald, in DB2 LUW V9.7, the INITCAP function might be what you are looking for:
SELECT INITCAP('AAA bb CCC dddd EEE')
Aaa Bb Ccc Dddd Eee
1 record(s) selected.
(I am not sure exactly what you mean by 'proper'.
Thank you for the recommendation. Maybe I should provide more information. I'm an enduser of DB2 Version 8 and when I query data, my description column contains text strings that are all in uppercase ex. (JOHN SMITH), I'm trying find out a way if there is a command like that would act like the "proper" function in MS Excel so the outcome would be "John Smith". I'm familar with the "lcase" function and also the "ucase" function.
I tried to incorporate the "INITCAP" function, and looked it up on the net, apparently there's no DB2 equivalent, but best suited for Oracle SQL.