Jonathan Hedstrom wrote:
> [EMAIL PROTECTED] wrote:
> > "SELECT replace(columname, 'chr(13)','') from tablename"
>
> Try using chr(13) without the single quotes:
>
> SELECT replace(columname, chr(13),'') from tablename
>
> or you could use '\r' to get the character:
>
> SELECT replace(columname,
[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
[EMAIL PROTECTED] wrote:
> "SELECT replace(columname, 'chr(13)','') from tablename"
Try using chr(13) without the single quotes:
SELECT replace(columname, chr(13),'') from tablename
or you could use '\r' to get the character:
SELECT replace(columname, E'\r','') from tablename
-Jonathan
begin
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
