I just recently imported some survey type data with linefeeds and caridge returns.
The data was imported into either a memo type column or a nvarchar (2000) type column.
(not my db)
Question... The CRLF are now represented by square blocks, how can I get them to display as
Perhaps this will help...
Here are two screen shots of what I'm trying to do.
-> this is how the data loaded
--> Is how I would like the data to appear - replacing CHR(127) with a CTRL-ENTER manually.