>>BTW, how can we see in SQL Server IDE the actual content of the field (with the line breaks)?
>
>Don't know. I can't find any settings to show non printable chars in the result.
>With this:
>
>CREATE DATABASE Test
>GO
>USE Test
>CREATE TABLE Test (Fld1 varchar(200))
>insert into Test VALUES ('asdasdasdasdas'+CHAR(13)+CHAR(10)+'asdasdasdasdasdasdasdasdasdasdasda')
>
>And then OPEN table from Object browser I can see two squares in the place of CHAR(13)+CHAR(10). But can't find a way to see them when I just run
>SELECT * from Test in New Query window.
Interesting again. If I open this in Object Browser I see nothing for these characters, e.g. they look as one line
But when I copy, they come correctly
First Line
Second Line
If it's not broken, fix it until it is.
My Blog