[thelist] Find-and-Replace in SQL

Wade Armstrong wade_lists at runstrong.com
Thu Sep 26 14:33:01 CDT 2002


I have a client who has changed their company's name. Many moons ago, we
built these folks a Web site with a content management system using SQL
Server 7.0 and ASP. Their site has grown to a couple hundred pages, and I'd
love to be able to just put in some SQL command like "REPLACE 'Old Company
Name' WITH 'New Company Name' IN table_name" but sadly it seems that REPLACE
doesn't work that way. Is there a way to do this in straight SQL?

Wade





More information about the thelist mailing list