ntext displayed in a data grid

[Guest]

I am retrieving a SQL ntext column from a table and inserting it into a
datagrid. However, it ignores line breaks so I get large blocks of
unformatted text. Is there a way to show the data as it is stored either by
doing some convert or cast in the SQL statement that retrieves the data or
some formatting in the data grid that recieves the data?

 

[Guest]

Unfortunately, replace won't accept an ntext field as the string to be
searched.