title: SQL Server Function that will return a text in HTML format
body: <p>I have a csv file that contains resume in plain text. I need to convert the text field from a text to html code.</p>
  
  <p>For example:</p>
  
  <p><strong>Plain text:</strong></p>
  
  <pre><code>Head
  
  Line2
  Line3
  Line4
  </code></pre>
  
  <p><strong>Converted:</strong></p>
  
  <pre><code>&lt;p&gt;Head&lt;/p&gt;
  
  &lt;p&gt;Line2&lt;br /&gt;
  Line3&lt;br /&gt;
  Line4&lt;/p&gt;
  </code></pre>
  
  <p>Can a SQL Server function can do this? I already saw a online tool <a href="http://www.textfixer.com/html/convert-text-html.php" rel="nofollow">http://www.textfixer.com/html/convert-text-html.php</a> that can do similar function, but I need to convert at least 1300 rows of resume that inside a csv file.</p>
  
  <p>Thanks in advance!</p>