Re: Capitalize first letter of FIRST word

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

Look into Oracle Text.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org