Hello, I have some varchar(2000) fields in my tables, and they have a lot of "weird" characters in them including line break and carriage returns, etc. When I do a select, I see the entire string of characters. When I pull them from a custom program, dts wizard, or just copy them to the clipboard, it truncates some of them. I'm guessing because it sees a line break or carriage return so it stops there. The result is that the extracted value is not the same as the original.
1. Is there a way to do a Select that converts the string to a byte array or similar so that I get the ascii value of every character?
2. Or is there a way to copy those values from one table to another? I've tried DTS Wizard, and it truncates the values.