title: How do I remove line feed characters when selecting data from SQL Server?
body: <p>I insert data that contains a line feed character into the database. Then I retrieve that data. I am using this script to attempt to remove the line feed while selecting the data from SQL:</p>
  
  <pre><code>Select Replace(Replace stringname,char(10),'',char(32),'')) from tablename
  </code></pre>
  
  <p>The replace function seems to execute, but it does not remove the line feed correctly.</p>