Replacing trademark symbol (™) in a varchar column

• j-1064772

  SSCertifiable

  Points: 5316

  More actions

  May 4, 2016 at 12:07 pm

  #1876696

  Does this help you ? It works on my machine.

  DECLARE @s-2 varchar(10) = CHAR(153);

  INSERT INTO Table_1 (sometext)

  SELECT @s-2 UNION ALL

  SELECT '1' UNION ALL

  SELECT @s-2 UNION ALL

  SELECT '2'

  SELECT * FROM Table_1

  UPDATE Table_1 SET sometext = REPLACE(sometext, @s-2, '?');

  SELECT * FROM Table_1;

  The first insert produces the following result:

  [font="Courier New"]

  sometext

  ™

  1

  ™

  2[/font]

• stickneym

  SSC Veteran

  Points: 224

  More actions

  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