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