* Roger Baklund > UPDATE table SET field=CONCAT(0,TRIM(LEADING '49' FROM field));
.. and this will of course prefix _all_ numbers with a '0', not only those that started with '49'... you should append WHERE field LIKE '49%' to you update statement. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
