I see in MaxDB there is initcap() function.
http://dev.mysql.com/doc/maxdb/en/71/81738fb9b311d2a97100a0c9449261/content.htm
> I have a table with upper case text. I want to use a function in my
> select
> statement the puts this text in title case so "MORE FOO YOU WIBBLE"
> becomes
> "More Foo Y
As far as I know INITCAP() isn't a valid function in MySQL. I believe it
is supported in Oracle (sqlplus).
--bmansell
-Original Message-
From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 1:00 PM
To: [EMAIL PROTECTED]
Subject: RE: Title Case Pr
Use INITCAP.
SELECT name, INITCAP(name) new_name
FROM customer WHERE firstname IS NULL
*** REPLY SEPARATOR ***
On 5/5/2004 at 12:43 PM Brian Mansell wrote:
>I may be wrong, but there isn't an easy method for completing this in
>SQL alone.
--
MySQL General Mailing List
I may be wrong, but there isn't an easy method for completing this in
SQL alone. If you're using PHP, process the field with ucwords( )
http://www.php.net/ucwords on the other hand, capwords() in Python does
something similar, but replaces multiple spaces with individual spaces.
--bmansell
-
