Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!apple!agate!shelby!portia.stanford.edu!mouser
From: mouser@portia.Stanford.EDU (Michael Wang)
Newsgroups: comp.databases
Subject: Re: Oracle Initcap
Keywords: oracle, initcap
Message-ID: <1990Sep14.192925.12519@portia.Stanford.EDU>
Date: 14 Sep 90 19:29:25 GMT
References: <36@genco.uucp>
Sender: mouser@portia.Stanford.EDU (Michael Wang)
Distribution: usa
Organization: AIR, Stanford University
Lines: 21

In article <36@genco.uucp> rad@genco.uucp (Bob Daniel) writes:
> In Forms 3.0, the initcap will capitalize the first character of each
> word properly but if I put my own cap in the middle of a word, initcap
> forces it back to lower case.  In a 'name' field, if you type in 'McCoy',
> it is converted to 'Mccoy'.  Is there a solution to this?

I'm not sure where you are using the INITCAP function, but you could 
try something like:

     SELECT INITCAP(SUBSTR(name_col, 1, 1)) ||
            SUBSTR(name_col, 2, LENGTH(name_col) - 1)
     FROM   table_name

You could hard code the length of the column in the second part if you
want to speed things up a tad.



Michael Wang
mouser@portia.stanford.edu