Re: Capitalize first letter of FIRST word

From: NetComrade <>
Date: Thu, 03 Apr 2008 16:57:03 GMT
Message-ID: <>

On Thu, 3 Apr 2008 01:19:29 -0700 (PDT), wrote:

>I have one long textfield that contains productinfo where everything
>is stored in ALL CAPS. I'd like to convert it to sentence case, that
>is, the first letter of each sentence capitalized.
>Initcap doesn't quite do the trick since it converts the first
>character in each word.
>Does anyone know of a sql-function that will do this? Or, has anyone
>written a function to do this, and if so, would they mind sharing the
>code? I'm using Oracle 9.2
>Tanks! Ragnar Husum

Find first space in a sentence, initcap everything to the left, lower everything to the right.

How do you know you don't have names and such that need to start with a capital? You might need to look into specialized software for this. .......
We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Apr 03 2008 - 11:57:03 CDT

Original text of this message