title: SQL Server Computed Columns - split on line break
body: <p>I have a column with name and address data in a single column:</p>
  
  <pre><code>Jo Bloggs
  Address Line 1
  Address Line 2
  PostCode
  </code></pre>
  
  <p>Is it possible to then create two computed columns based on this, and if so how? e.g.</p>
  
  <p>RecipientName</p>
  
  <pre><code>Jo Bloggs
  </code></pre>
  
  <p>Address</p>
  
  <pre><code>Address Line 1
  Address Line 2
  PostCode
  </code></pre>
  
  <p>I'm using SQL Server 2005</p>