title: SQL: Insert a linebreak in varchar string
body: <p>I've searched StackOverflow for all the possible solutions concerning how to insert a linebreak in a SQL text string. I've referred this link but to no avail. <a href="https://stackoverflow.com/questions/31057/how-to-insert-a-line-break-in-a-sql-server-varchar-nvarchar-string">How to insert a line break in a SQL Server VARCHAR/NVARCHAR string</a></p>
  
  <p>But none of the solutions are working for me.</p>
  
  <p>This is what I'm trying to do:</p>
  
  <pre><code>insert into sample (dex, col) 
  values (2, 'This is line 1.' + CHAR(13)+CHAR(10) + 'This is line 2.')
  </code></pre>
  
  <p>But this is the output generated: (Select Col from sample where dex = 2)</p>
  
  <blockquote>
    <p>This is line 1.  This is line 2.</p>
  </blockquote>
  
  <p>This is the output that I desire:</p>
  
  <blockquote>
    <p>This is line 1.<br>
    This is line 2.</p>
  </blockquote>
  
  <p>I'm using SQL server and SSMS if that helps.</p>
  
  <p>Any ideas why it isn't working?</p>