>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

If you copy from NotePad to Word, are paragraphs preserved? How do you verify that the paragraphs are gone? Do you output to a text file?