title: how to use sql for xml path('') but retain carriage returns
body: <p>i have the following piece of code</p>
  
  <pre><code>select
      (
      select cast(Narrative as Varchar(max)) + char(13) 
      from officeclientledger 
      where ptmatter=$matter$ and ptTrans=4 
      for xml path (''), type
      )
  </code></pre>
  
  <p>which deliver results such as:</p>
  
  <blockquote>
    <p>Cwm Taff NHS Trust Medical Records
    <strong>&#x0D ;</strong> Dr Purby Medical Records <strong>&#x0D ;</strong>
    <em>(excluding spaces, needed to insert for the purpose of asking the question)</em></p>
  </blockquote>
  
  <p>however, is there a way of delivering the results such as</p>
  
  <blockquote>
    <p>Cwm Taff NHS Trust Medical Records</p>
    
    <p>Dr Purby Medical Records</p>
  </blockquote>