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 no luck. Could someone help me rid this table of its
embedded returns?
Thanks in advance...
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
