Home Forums SQL Server 2017 SQL Server 2017 - Development Replacing hidden characters RE: Replacing hidden characters

  • March 13, 2018 at 9:12 am

    #1982955

    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?

    Any chance that the characters are NOT contiguous?   You could test for this as follows:
    SELECT REPLACE(REPLACE(Column1, CHAR(0xC2), ''), CHAR(0x92), '')

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)