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 Problem 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 For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]