title: Selecting <br/> in FOR XML PATH Query in sql server
body: <p>I have written following SQL Query :</p>
  
  <pre><code>SELECT SUBSTRING(
  (
      SELECT  ', &lt;br /&gt;'+  
      [tblSectors].[title]
       FROM tblSectors  WHERE 1=1  AND  sector_id IN 
       (SELECT sector_id FROM tRelBusinessSector WHERE business_id = 2517)
  FOR XML PATH('')),2,200000) AS CSV
  </code></pre>
  
  <p>it displays following output :  <code>&amp;lt;br /&amp;gt;Personal Injury, &amp;lt;br /&amp;gt;Financial products/services</code></p>
  
  <p>It doesn't display <code>&lt;br/&gt;</code> in the output ?? why ??</p>