I'm using varchar(Max) to store a text file content. It's not taking the newline character. I tried \n and char(13) etc.. whatever solution posted in the net.
ex : update test set f='This is line 1.' + CHAR(13) + CHAR(10) + 'This is line 2.'
after updating it doesn't have any newline or linebreak. Can anyone help me in this how to have linebreaks in the varchar(max) field.
Thanks a lot.
View Complete Post