Migrate columns which have carriage return and line feed

[indian143]

Hi All, I am migrating data from one table another table in different databases. When source table has line feed and carriage return the destination table is not getting that. All I am doing is inserting the records using select statements. Can anybody please help me by giving a suggestion how to select columns by preserving line feed and carriage return characters. I am also searching if you know sure that would be helpful. Thanks in advance.

Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

[Lost User]

Your code must be doing something to change the data. The SQL should return exactly what is stored in the database for each record.

[CHill60]

Can you share a sample of the code?

[indian143]

Sorry, yeah it was code issue, thanks for all your support friends.

Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."