Hello, 1-I am trying to capialize the first letter of each word in a ceratin filed:
SELECT CONCAT( UPPER( SUBSTRING( cat_name, 1, 1 ) ) , LOWER( SUBSTRING( cat_name, 2 ) ) ) FROM `cateogries` It is only doing it for the first word. if the category has more than one word separated by (space) the others are left in lower case 2- Assume I want to update the result directly in the database, is there anyway to automatically do it in one statement like: (select replace....) Georges -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]