I have a field that has been given to me as all uppercase, they are City names, some are more than one word.
I need to run a update to: replace " " with " " then lowercase them all, then uppercase the first letter and any first letter after a space. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]