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"
&g
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
--bmansell
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 11:25 AM
To: '[EMAIL PROTECTED]'
Subject: Title Case Problem
Hi All,
I have a table with upper case text. I want to use a function in my
select statement the puts this t
In the last episode (May 05), Andrew Braithwaite said:
> 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 You Wibble".
MySQL doesn't provides a f
Hi All,
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 You Wibble".
Thanks for any help
Cheers,
Andrew
Sql, query
--
MySQL General Mailing List
For
Hi All,
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 You Wibble".
Thanks for any help
Cheers,
Andrew
Sql, query
--
MySQL General Mailing List
For
