RE: Replacing hidden characters

SSC Guru

Points: 1003895

March 13, 2018 at 8:06 pm

#1983081

SQLHeap - Tuesday, March 13, 2018 8:35 AM
I'm to replace 2 hidden characters CHAR(0xC2) and CHAR(0x92).
SELECT CHAR(0xC2) CHAR1, CHAR(0x92) CHAR2

I can select them and replace them with this:
SELECT REPLACE(Column1, CHAR(0xC2) + CHAR(0x92), '')
, but can't replace them when selecting from the table. Any ideas why?

Can you post the actual code that you're using when trying to select from the table along with the datatype and collation of the column in question, please?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)