removing carriage return in data extraction

I'm getting what I think is a carriage return in my result set.  When I spool the results to text, there's a vertical rectangular character in the text file, and when I import this dataset into Excel it will cut off the row and go to the next row where the character appears.  I've tried the return and trim functions but they don't seem to work.  can someone help?  thanks.
Who is Participating?
slightwv (䄆 Netminder) Commented:
verify the ascii value of the 'box' (It's commonly called a Glyph).

Then just REPLACE(mytext,chr(10),' '), assuming it is a CR
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.