[thelist] Interesting SQL Mass update

Chris Blessing webguy at mail.rit.edu
Mon Oct 28 10:37:01 CST 2002


Rob-

Try:

UPDATE tblFoo
SET URL = replace(URL, ' target="_blank"', '')

That'll just remove the target= part and the leading space.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> Hi Jay,
>
> I asked for that. Perhaps I should refine my problem. The URL links are
> different for most fields (*.dbo.ProductMedia). From the UPDATE query you
> listed, wouldn't that update all to be 1. I just want to extract a part of
> the string from inside different and not alike strings.
>
> Rob




More information about the thelist mailing list