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 -----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 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 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]
