>I looked at the code. There is nothing extra, the text I was passing was
>
>"// Comment Test\n\nSUB(BASE G1) \nSUB(FACTORS) \nSUB(2GM1) \nSUB(3+GM1) \nROUND(1.00)"
>
>and I got exactly same text back as well. I'll look in the SQL Server now.
>
>When I changed Query Output to text it also looks correct to me.
>
>So, perhaps there is no problem at all.
I did paste that text into a VarChar(MAX) field and it was saved ok. I was able to display it back into a HTML form as is.
However, in that text, carriage returns are being represented by special characters. Did the user do a carriage return or entered the equivalent in that encoding syntax?