[snip] Unfortunately the item field has got data with quotes around it. IE "KP-00310". I need to clean up the data and have the field contain just KP-00310. Since I have 10,000 records, I need a update statement or something to clean that up.
Any ideas ? [/snip] http://dev.mysql.com/doc/mysql/en/string-functions.html the manual is your friend UPDATE item SET item = REPLACE(item, '"', '') -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]