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

When you open the table for editing you can resize the row height. Resize it to be a little bit taller. Resize also Row width.
Then click on that field and press home.