title: Implode type function in SQL Server 2000?
body: <p>Is there an Implode type function for SQL Server? </p>
  
  <p>What I have is a list (in a SQL server table):</p>
  
  <pre><code> Apple
   Orange
   Pear
   Blueberry
  </code></pre>
  
  <p>and I want them to come out as </p>
  
  <pre><code> Apple, Orange, Pear, Blueberry
  </code></pre>
  
  <p>I hope for the space and comma to be configurable but I can always replace it if it isn't... </p>
  
  <p>Quick help would be appreciated! </p>