I am trying to remove a pesky hidden character from a string.
The hidden character looks like a blank space, but when I copy/paste it into MsWord, and use the Show Paragraph/Formatting Marks option, the symbol it reveals looks something like the DEGREE symbol, i.e. a small circle. I've attached (I hope) a JPEG screencap of the symbol. It appears at the end of the sentence, between the period and the paragraph mark.
I have tried using the following UPDATE code to get rid of it, where tblWeirdChar houses the string with the pesky char:
SET MyString = REPLACE(MyString,' ','')
But that didn't work; I guess SQL Server knows that it's not a blank space.
I also tried RTRIM, but that didn't work either.
Can anyone advise?
DBA, Fulcrum Publications, Inc.