I have a legacy database in SQL 2005, and am using queries to extract data from the tables. Some of the tables are text and contain imbedded Carriage Returns [chr(13)] to produce intentional multi-line fields. The SELECT statements are used to extract data from the legacy database, put into Excel for data cleanup purposes, and ultimately loaded into a new database.
However, the imbedded CR's appear to be converted to blanks, so the resulting fields are single-lines. How can I preserve the CR's from the legacy database in the SELECT statement output?