The initcap function can work pretty well in a lot of cases but those exceptions can be major. I remember there being discussions on this list about how does one handle names starting with Mc or Mac. At the time the original post came in I was dealing with some strings that included the degrees MD and PhD and I know of no way initcap will handle those correctly.
Pat > > Do you know initcap function? > > > SELECT INITCAP('the soap') "Capitals" FROM DUAL; > > Capitals > --------- > The Soap -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).