[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