nText and String manipulation. SQL Server


Parent question- Thanks to Paul White and Tom V for the answer.



I am making little modification's to Paul White's answer to suit my requirements.



I would like to change the following to replace a string instead of inserting:



Column value:



Expected result:



Current result:



This is the closest to the solution I can get. But this is not working!



This is the error I am getting:



Incorrect syntax near '@length'. (Line 10)



I have updated as given below to update all instances of the matching string



Column value:



Expected result:



Current result:



Please help with the following:






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

The Dalles, Oregon

眉山市

清晰法令