Hello,
I have a nVarChar(max) field. I have several short stories that I want to paste into the fields -- 1 story per record.
Each story has several paragraphs.
When I copy the entire story from NotePad and paste it into one of the nVarChar(max) fields, the paragraphs are not respected and everything runs together.
I find that if I programatically paste one paragraph at a time along with a concatenated "\n", the nVarChar(max) field does respect the paragraphs.
Of course, that is an awful lot of cutting/copying/pasting for each story.
What is the easiest way to copy and paste the stories into the nVarChar(max) fields and maintain the paragraph formatting?
Thanks,
TFISHER
Thanks,
TFISHER