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 !