I have a table that store email body
I extract into json format in a store procedure
"emailTexts": [
{
"id": 1,
"body": "Dear Sir\r\n Greetings!\r\n ThankYou",
}
How can I remove this, at the same time, i will need to send the same format to another system
1条答案
按热度按时间bvjveswy1#
I am not really sure you would want to do such a thing. Anyway, you could use Replace(). ie:
Or (to deal with all occurrences of \r \n \t):
PS: If you would do this on large data then consider creating a CLR function instead.