title: &amp; instead of & in STUFF FOR XML PATH
body: <p>I am using <code>STUFF</code> function. I have some entries having <strong>&amp;</strong> but shows <strong>&amp;amp ;</strong> instead. Somewhere I read that &amp; is reserved in XML. How to solve this.</p>
  
  <pre><code>...STUFF((SELECT (', ' + CategoryName) FROM CategoryTable WHERE CategoryId IS NOT NULL AND CategoryId IN (1,2,3) FOR XML PATH('')), 1, 1, '') as CategoryName,...
  </code></pre>
  
  <p>Above is my query (Well I have just added a part of a full query.). How to solve. Thanks.</p>