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

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

RE: SQL find and replace tool or roll my own in CF

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

Re: SQL find and replace tool or roll my own in CF

You can access all the tables/fields programatically -- the systables and syscolumns tables have the schema embedded in them -- with a little manipulation you can generate a list of all coumns in the entire database, loop through in a cursor, and and run the replace on the column. Here's the SQL