Re: Capitalize first letter of FIRST word

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 04 Apr 2008 17:45:41 +0200
Message-ID: <2019a$47f64d26$524b5c40$1970@cache4.tilbu1.nb.home.nl>


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

Define "sentence" in Oracle terms (and no, anything that ends with 'dot-space' is not covering everything). Skip spaces to the next character, and inicap that.

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Fri Apr 04 2008 - 10:45:41 CDT

Original text of this message