>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.