title: Data in a table with carriage return?
body: <p>In SQL SERVER Is it possible to store data with carriage return in a table and then retrieve it back again with carriage return.</p>
  
  <p>Eg:</p>
  
  <pre><code>insert into table values ('test1 
  
  test2
  
  test3
  
  test4');
  </code></pre>
  
  <p>When I retrieve it, I get the message in a line </p>
  
  <p>test1  test2  test3  test4</p>
  
  <p>The carriage return is treated as a single character.</p>
  
  <p>Is there way to get the carriage returns or its just the way its going to be stored?</p>
  
  <p>Thanks for the help guys!!!</p>
  
  <p>Edit: I should have explained this before. I get the data from the web development (asp .net) and I just insert it into the table. I might not be doing any data manipulation.. just insert.</p>
  
  <p>I return the data to the app development (C++) and may be some data or report viewer.</p>
  
  <p>I don't want to manipulate on the data.</p>