Re: Capitalize first letter of FIRST word
Date: Thu, 03 Apr 2008 16:57:03 GMT
Message-ID: <5r2av39gqc9pgj3fsm5brvfv64i6k1vcat@4ax.com>
On Thu, 3 Apr 2008 01:19:29 -0700 (PDT), ragnar.husum_at_gmail.com 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