Re: Capitalize first letter of FIRST word

From: DA Morgan <>
Date: Thu, 03 Apr 2008 08:54:15 -0700
Message-ID: <> 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

Look into Oracle Text.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Apr 03 2008 - 10:54:15 CDT

Original text of this message