Initcap and roman numerals
438488Feb 28 2006 — edited Mar 1 2006I working on a query and the client wants the name to show as proper case so I used the initcap function and it works perfectly except in certain instances the last name column and a roman numeral at the end. The initcap on capitalizes the first character but leaves the second lower. Is there a way to have the function stop this or do I have to create a customer function? Also if I have to create a customer function could offer some kind of example to assist me in writing it, since I'm still a newbie to oracle.