When completing a replace on a set of data using a list of non-standard ascii characters, the string 'TH' is being replaced as it has been identified as the Thorn (þ) character
Any suggestions on how to stop this from happening? An example with the simple line of code below shows the issue where i'd expect it to return 'TH' instead of 'X'
SELECT replace ('TH','þ','X')
I have used Collate and the various fixes shown in the link below
Selecting based on Thorn character MS SQL Server
However nothing I try seems to work
Thanks!
