title: Oracle REPLACE() function isn't handling carriage-returns & line-feeds
body: <p>We've a table with a <code>varchar2(100)</code> column, that occasionally contains carriage-return &amp; line-feeds. We should like to remove those characters in the SQL query. We're using:</p>
  
  <pre><code>REPLACE( col_name, CHR(10) ) 
  </code></pre>
  
  <p>which has <strong>no effect</strong>, however replacing 'CHR(10)' for a more conventional 'letter' character proves that the REPLACE function works otherwise. We have also found that </p>
  
  <pre><code>REPLACE( col_name, CHR(10), '_' ) 
  </code></pre>
  
  <p>finds the <em>location</em> of the new-line, but <em>inserts</em> the underscore after it, rather than replacing it.</p>
  
  <p>Running on Oracle8i. Upgrading is not an option.</p>