Compressed data

[tthandle]

I am having a problem using a form to I am using a form to upload data from ASP to SQL Server 2000 hosting site. When I see the data it looks fine however when a sql is run to return the data the data is compressed. How can I return the data as I see it using the SQL Query Analyzer. For example when I am loading the data it looks like this:
The boy ran down the street.

The girl followed.

The boy ran further.

The data appears exactly as you read it with blank lines using the SQL Query Analyzer. However, when it is return it displays:
The boy ran down the street. The girl followed. The boy ran further.

I would like the blank lines to remain. I am using ntext in the column. (column_name,ntext,16)

Please help.

Thanks in advance!

 

[codestorm]

How about ..
<%
dim str_Temp
str_Temp = obj_Rst.Fields(&quot;Field1&quot
str_Temp = replace(str_Temp, chr(13) & chr(10), &quot;<br />&quot
Response.write str_Temp%>
<insert witticism here>
codestorm

 

[tthandle]

I am having a problem using a form to I am using a form to upload data from ASP to SQL Server 2000 hosting site. When I see the data it looks fine however when a sql is run to return the data the data is compressed. How can I return the data as I see it using the SQL Query Analyzer. For example when I am loading the data it looks like this:
The boy ran down the street.

The girl followed.

The boy ran further.

The data appears exactly as you read it with blank lines using the SQL Query Analyzer. However, when it is return it displays:
The boy ran down the street. The girl followed. The boy ran further.

I would like the blank lines to remain. I am using ntext in the column. (column_name,ntext,16)

Please help.

Thanks in advance!

 

[codestorm]

I listed the solution above.. <insert witticism here>
codestorm