2
Given your test data, this will parse out the section of the string you want between either the first semi-colon after the PATH=, or the end of the string if that doesn't exist. From here, you should be able to use an update to replace that section of the string.
Further reading: Get The Text Between Two Delimiters
SELECT
x.*,
SUBSTRING(x....
1
I want to change a part of some strings in the PARAMETERLIST column.
This is just one of the reasons that you do not store multiple data items in a single column.
Any "string" manipulation on these values is going to be complicated, cumbersome and, most importantly, slow. Don't do it (any more).
Normalise your data and break these mini-monoliths ...
1
This is an easy one. Albeit if you work in a Swiss-German organisation like I do and have to install German SQL Server instances on Windows Servers, which have been set up to use the location Switzerland which results in a Swiss-German keyboard layout and date-time settings.
The solution depends on the version of the OS installed...
Windows Server 2016
On a ...
Only top voted, non community-wiki answers of a minimum length are eligible
