Re: [GENERAL] remove embedded carriage returns

2007-01-11 Thread chwy_nougat
[EMAIL PROTECTED] wrote: > Outputting a SELECT statement's results to ascii file showed me a table > with a bunch of embedded carriage return characters in the values. I > want to remove the embedded returns, so I read the documentation and > tried a few variations on "SELECT replace(columname, 'c

[GENERAL] remove embedded carriage returns

2007-01-10 Thread chwy_nougat
Outputting a SELECT statement's results to ascii file showed me a table with a bunch of embedded carriage return characters in the values. I want to remove the embedded returns, so I read the documentation and tried a few variations on "SELECT replace(columname, 'chr(13)','') from tablename" with n