Home Forums SQL Server 2005 SQL Server 2005 General Discussion Replacing trademark symbol (™) in a varchar column RE: Replacing trademark symbol (™) in a varchar column

  • May 5, 2016 at 12:06 pm

    #1876939

    have you tried

    REPLACE(PRODUCTDESC,nchar(8482),'')

    There is NO representation for Trademark in the 850 character set

    Your field MUST be defined as nvarchar before you load the data into the table