T-SQL is a possibility but, I may have overly simplified the problem. The client database is made up of about 128 tables. About 1/2 of them may contain the items I want to strip/replace. And there may be up to 5 fields in each table that may need to be searched. I guess what I am looking for is a solution that will do a search/replace on all fields in all tables in the database.
Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -----Original Message----- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 9:07 AM To: CF-Talk Subject: Re: SQL find and replace tool or roll my own in CF Why wouldn't you use T-SQL? Easy enough to query the data and use the REPLACE, PATINDEX,etc to remove the text you're after. That is *far* easier than a CF app. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Mark W. Breneman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 16, 2003 9:39 AM Subject: SQL find and replace tool or roll my own in CF > We are just about to start a major website redesign for one of our clients. > In the SQL 2000 database they have stored 3-5 page articles with url links > referring to pages that will no longer have that name after the website > redesign. The second step we want to take is to remove all font tags that > the client may have stored in the database. > > I am wondering if anyone has a tool that works well for searching and > replacing the data stored in several tables or if I should write something > in CF to do just that. > > Mark W. Breneman > -Macromedia Certified ColdFusion Developer > -Network / Web Server Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4