> >you should be able to use STR_REPLACE. > DOH. Sorry, there is NO STR_REPLACE its just REPLACE. > jd > > >update 02093_xdir_links SET title = REPLACE("*","",title);
Thank you very much for responding. Sorry to be dense but will this SQL find only those records with data in the TITLE field that are bracketed in double quotes and remove ONLY the quotes? E.g., Change the record from: Id Title Address City State Zip 1 "Joe" 1313 Mockingbird Lane Transylvania PA 02098 ^^^^^ To: Id Title Address City State Zip 1 Joe 1313 Mockingbird Lane Transylvania PA 02098 ^^^ To my untrained eye it looks like the REPLACE, as you wrote it above, searches the title field for anything e.g., "*". And replaces it with nothing "". Thanks. Bob Cohen b.p.e.Creative http://www.bpecreative.com Design and production services for the web Put creative minds to work for you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]