<< ...is there a better, faster was to do this in SQL directly, preferably replacing "\s*\r\n\s*" so that it replaces the line break and any leading or trailing whitespace replacing it with one single space character. >>
I'm not sure if this will work with the spaces but it seems it might. Doing a mass replace in MySQL is fairly easy. The query format is ... UPDATE table_name SET column_name = REPLACE(column_name,"original_string","replace_string") In this example, UPDATE `Clients` SET `last_name` = REPLACE(`last_name`,"Smith","Jones") Hope this helps. Jeff Horne ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234998 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54