[thelist] Interesting SQL Mass update

Rob Smith rob.smith at THERMON.com
Mon Oct 28 10:47:01 CST 2002


Cool!

That worked nicely.

Thanks all who've helped me on this one.

<tip type="Good web design" author="Rob.Smith">
If you use splash pages for your websites, please include a some sort of
navigation that's visible and intuitive for the user to understand. No
mystery meat links please.
</tip>

Rob

-----Original Message-----
From: Chris Blessing [mailto:webguy at mail.rit.edu]
Sent: Monday, October 28, 2002 10:41 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Interesting SQL Mass update


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

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !



More information about the thelist mailing list