>Hmm, and with this:
>

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

>(check the syntax, I didn'y :o))

Oops, I was looking originally at the wrong column (I selected everything).

With the new code I see

First line~#Second line~#Third line~#~#Fifth Line

The original code also worked, so they are indeed line breaks, just don't visible in SQL Server IDE.

Now, why they are not displayed properly on the page when it's created? :(