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]