title: Remove carriage return / Line feeds in string and output with quotes
body: <p>I have the following SQL that outputs a string with double quotes around it:</p>
  <pre><code>SELECT '&quot;'+A.DESCR+'&quot;'
  FROM MyTable
  
  Results:
  &quot;Stackable Storage Basket&quot;
  </code></pre>
  <p>I have found that I have carriage returns / line feeds in some of the data and want to remove any of these while retaining the quotes. I have modified the code as below, however this is adding an extra quote onto the end of the string, and not retaining the beginning quote either.</p>
  <pre><code>SELECT REPLACE(REPLACE(DESCR + '&quot;'+DESCR+'&quot;' + '''', char(10),'&quot;'), char(13), '&quot;')
  FROM MyTable
  
  Results:
  Stackable Storage Basket&quot;'
  </code></pre>
  <p>How do I need to modify this to get the expected behavior?</p>