title: How to split a multi-line string into columns in tsql
body: <p>I have a database field that contains address information stored as multi-line strings.</p>
  
  <pre><code>88 Park View
  Hemmingdale
  London
  </code></pre>
  
  <p>Could anyone tell me the best way to get line 1, line 2 &amp; line 3 as distinct fields in a select statement?</p>
  
  <p>Regards
  Richard</p>