>>Have no clue.
>>I have no idea why your front end don;t present the data properly.
>>Maybe if you ask that question n NET forum,...?
>
>First I need to find out the code producing the output.
>
>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.