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