[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:vcard fn:Jonathan Hedstrom n:Hedstrom;Jonathan org:Downtown Emergency Service Center;Information Services email;internet:[EMAIL PROTECTED] title:Data Systems Administrator tel;work:(206) 464-1570 ext. 3014 version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
