[thelist] Interesting SQL Mass update
Lonnie.Kraemer
lwkraemer at directvinternet.com
Mon Oct 28 10:45:01 CST 2002
> I've got a small table, about 1000 rows or so, and some of the columns
have
> something like this in it:
> <a href="../links/page1.html" target="_blank">
>
> I want to remove the 'target="_blank"' part of the string. Is there a
way to
> do this mass update in SQL? I could probably do in ASP, but don't want
to
> have to resort to that - time.
This should work:
strSQL="UPDATE tbl SET linkfield='" & replace(linkfield,"
target="_blank"","") & "'"
--
Lonnie Kraemer
-----------------------------------------
More information about the thelist
mailing list