>Hi everybody,
>
>I have a varchar(1000) field for the Description. On the front end (ASP.NET page) I type info with line breaks. In the SQL Server I see line breaks as spaces when I open table or when I do a select.
>
>Is there anyway to see the actual content on the field?
>
>Somewhere in between saving this file and generating a new page with the description the line breaks disappear.
>
>Thanks in advance.

What happens if you SELECT that field that way:

SELECT REPLACE(YourField, CHAR(13)+CHAR(10),'~~')
       FROM YourTable

Did you see any '~~' in the result?