Re: remove embedded carriage returns

[Jonathan Hedstrom <jhedstrom@xxxxxxxx>]

chwy_nougat@xxxxxxxxx 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:vcard
fn:Jonathan Hedstrom
n:Hedstrom;Jonathan
org:Downtown Emergency Service Center;Information Services
email;internet:jhedstrom@xxxxxxxx
title:Data Systems Administrator
tel;work:(206) 464-1570 ext. 3014
version:2.1
end:vcard