Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
<test attr="http://www.link.com/abc"/> <test attr="http://www.link.com/def"/> <test attr="www.link.com/xyz"/>
UPDATE dbo.test SET testCol = replace(testCol, 'www.link.com', 'www.mylink.com') WHERE testCol LIKE '%www.link.com%';
testCol.modify('replace value of xpath-expression with new-value')
<test attr="http://www.mylink.com/abc"/> <test attr="http://www.mylink.com/def"/> <test attr="www.mylink.com/xyz"/>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.