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!
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!