title: How to print out new lines from SQL Server table?
body: <p>Let's say I have a this value in my database</p>
  
  <pre><code>"line 1 &lt;br/&gt; line 2 &lt;br/&gt; line 3"
  </code></pre>
  
  <p>When I display it through using select statement and paragraph tag like this</p>
  
  <pre><code>&lt;p&gt; @item.value &lt;/p&gt;
  </code></pre>
  
  <p>it prints out the same single line. What should I insert to the values in the database in order to read the break lines tags ?</p>
  
  <p>I tried to replace the <code>&lt;br&gt;</code> tags with <code>char(13)</code> / <code>char(10)+char(13)</code> / <code>\n</code> and it didn't work.</p>