[thelist] Interesting SQL Mass update

Jay Blanchard jay.blanchard at niicommunications.com
Mon Oct 28 10:26:01 CST 2002

SET URL = '<a href="../links/page1.html">'
WHERE URL LIKE '%target="_bl%'

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.



More information about the thelist mailing list