0
how do I remove special characters from a string in a query in SQL Server with tags in html, xml and others?
Current result:
<!--[if !mso]><styl>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:*...
I tried to use char, but without success. Follow the query below.
select
REPLACE(REPLACE(m.msg_body, CHAR(13), ' ' ),CHAR(10), ' ' ) as Descrição
from service_req_msg m
Woe, but what you wanted me to show?
– Sorack
@Sorack, the text contained in it. In this case "Dear, please show..."
– Renan Bessa
But in your example there is no such text anywhere
– Sorack