[thelist] Interesting SQL Mass update

[Jay Blanchard]

[snip]
UPDATE tblFoo
SET URL = '<a href="../links/page1.html">'
WHERE URL LIKE '%target="_bl%'
[/snip]

Of course, this won't really work, because it will set all of the column
items the same. What you need to do is write a small ASP script that will
read in each row of the table, modify the line, and then updating. Check
MSSQL for a truncate function though, you may be able to run a query that
truncates everything in the column a certain number of characters distance.

HTH!

Jay