Re: Capitalize each word in a string ?
Jason's solutions (a clever one, may I say) works fine only for one word. Not for EACH word as the topic states.
select CONCAT(UPPER(SUBSTRING('mARC sABAT',1,1)),LOWER(SUBSTRING('mARC sABAT',2))) as mystring
This outputs:
Marc sabat
Edited 1 time(s). Last edit at 05/02/2009 04:00AM by Marc Sàbat.
Subject
Views
Written By
Posted
24986
May 15, 2007 11:28AM
15411
May 15, 2007 03:18PM
7333
March 05, 2008 07:47AM
7001
March 05, 2008 10:22AM
6462
July 25, 2008 08:21AM
6281
August 20, 2008 01:32AM
6139
August 24, 2008 07:50AM
5522
September 15, 2008 01:33PM
7104
November 11, 2008 07:11AM
5009
August 24, 2008 07:52AM
Re: Capitalize each word in a string ?
4001
May 02, 2009 03:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.