Naomi,

Write three short paragraphs in word that has space between the paragraphs. Then select all of it and copy into your buffer. (control -c)

Now open SQL Server and create a new record in SSMS in a table that has a field of varchar(max) and try to paste that into the column on a new row. It will only paste the first paragraph because the codes in word that create the paragraph of line breaks will prevent anything after them from being entered into the column. In order to get paragaphs in you have to copy and paste each paragraph seperately.

This is the question he is asking. how do you get large chunks of text data into a sql varchar(max) column when he has it already stored in word documents.
Tim

>>Hello,
>>
>>Thanks for the suggestion, but that does not work. It just displays the text along with the codes.
>>
>>I can copy the information out of the nVarChar(max) field (from one that I have programmatically concatenated) and paste it into Word and it respects the paragraphs -- yet, in the nVarChar(max) field in SQL, you do not see any of the codes.
>>
>>Thanks,
>>
>>TFISHER
>>
>>
>>
>>>In the web page you need to replace paragraphs with either

<br/><br/> or with <p> and </p>

at the end.
>>>Unless you're using PRE tag preserving the paragraphs.
>
>Can you show the code used to display this info in the Web Page?