Removendo caracteres especiais da descrição de produtos

Usaremos o comando REPLACE para remover os caracteres especiais, usando a Tabela ASCII para verificar os caracteres, os caracteres removidos no comando serão os seguintes abaixo.

! " # $ % & ' ( ) * + , - . / : ; < = > ? @ ^ _ ] \ [ ` { | } ~  € ‚ ƒ „ … † ‡ ˆ ‰ Š ‹ Œ  Ž   ‘ ’ “ ” • – — ˜ ™ š › œ  ž Ÿ   ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ´ µ ¶ · ¸ º » ¼ ½ ¾ ¿ Æ Ð × Ø ø ÷ Þ ß ñ ð æ

• Execute o comando abaixo no Management Studio

update produto
SET nome = (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(nome,char(33), ''),char(34), ''),char(35), ''),char(36), ''),char(37), ''),char(38), 'E'),char(39), ''),char(40), ''),char(41), ''),char(42), ''),char(43), ''),char(44), ''),char(45), ''),char(46), ''),char(47), ''),char(58), ''),char(59), ''),char(60), ''),char(61), ''),char(62), ''),char(63), ''),char(64), 'A'),char(94), ''),char(95), ''),char(93), ''),char(92), ''),char(91), ''),char(96), ''),char(123), ''),char(124), ''),char(125), ''),char(126), ''),char(127), ''),char(128), 'E'),char(130), ''),char(131), 'f'),char(132), ''),char(133), ''),char(134), ''),char(135), ''),char(136), ''),char(137), ''),char(138), 'S'),char(139), ''),char(140), ''),char(142), 'Z'),char(145), ''),char(146), ''),char(147), ''),char(148), ''),char(149), ''),char(150), ''),char(151), ''),char(152), ''),char(153), ''),char(154), 's'),char(155), ''),char(156), ''),char(158), 'z'),char(159), 'Y'),char(160), ''),char(161), 'i'),char(162), 'c'),char(163), 'E'),char(164), ''),char(165), ''),char(166), ''),char(168), ''),char(169), ''),char(170), 'a'),char(171), ''),char(172), ''),char(173), ''),char(174), 'R'),char(175), ''),char(176), ''),char(177), ''),char(180), ''),char(181), 'u'),char(182), ''),char(183), ''),char(184), ''),char(186), 'o'),char(187), ''),char(188), ''),char(189), ''),char(190), ''),char(191), ''),char(198), 'E'),char(208), 'D'),char(215), 'x'),char(216), 'O'),char(248), 'o'),char(247), ''),char(222), 'b'),char(223), 'B'),char(241), 'n'),char(240), 'd'),char(230), 'e'))
WHERE   (PATINDEX('%[!#$%&()*+,-./:;<=>?{|}~€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ¡¢£¤¥¦§¨©ª«¬®¯°±²³´µ¶·¸¹º»¿ÆÐ×ØÞß÷ø]%', Nome) > 0);

Base comando: UPDATE tabela set coluna = (REPLACE(coluna, 'caracter incorreto','caracter novo'))

Para saber qual caracter é respectivo ao numero, consulte a Tabela ASCII disponivel abaixo e busque diretamente no sql com o comando a seguir, colocando a numeração entre parênteses: SELECT CHAR( )