title: How can I pull a list of ID's from a SQL table as a comma-separated values string?
body: <p>I have to pull a list of integer IDs from a table using only records that match some criteria. For example:</p>
  
  <pre><code>Select ProdID From Products Where (ProdType='XYZ');
  </code></pre>
  
  <p>The catch is that I have to return it as a set of comma separated values so I can use it to select items in a multi-select list:</p>
  
  <pre><code>111,231,554,112
  </code></pre>
  
  <p>rather than as records.  I do not want to do this in my C# code - I'd like it to come right out of the database via a query this way.  Any ideas?</p>