Re: remove embedded carriage returns

chwy_nougat@yahoo.com 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