title: SQL Remove Carriage return
body: <p>The data I am extracting contains carraige returns, I am not able to export the data and do any analysis on it.</p>
  
  <p>i.e </p>
  
  <pre><code>Select system_outcome , contact_list_name , agent_classification , timestamp_dtm , phone_number, agent_name
  From call_stats_view
  Where date(timestamp_dtm) BETWEEN '2016-11-10' AND '2016-11-10'
  </code></pre>
  
  <p>This should give me a </p>
  
  <pre><code>Answered, Contactlist1, Sale, 2016-11-10, 07777777777, John King
  </code></pre>
  
  <p>when i extract the information it all ends up on different lines any idea how i can get around this?</p>