title: Remove trailing comma from xml path
body: <p>How do I remove the trailing comma from the result of this query:</p>
  
  <pre><code>SELECT CONVERT(varchar(10), clientid) + ','
  FROM daily
  FOR XML PATH('')
  </code></pre>
  
  <p>The output is <code>0,0,351,350,</code></p>
  
  <hr>
  
  <p>This is not a duplicate. The other questions are not using xml path, but I am. </p>