title: Building SQL "where in" statement from list of strings in one line?
body: <p>I have a List(Of String) which corresponds to "types" on our database table.</p>
  
  <p>We are using the DB2 ADO.NET provider and my final query needs to look something like this:</p>
  
  <pre><code>select * from table where type in (@type1, @type2, @type3, @type4)
  </code></pre>
  
  <p>In the past, I've built the list of query parameters / host variables using a ForEach loop, but I would really like to figure out a way to build them in one line. Of course, I can join all of the strings, but adding the "@" and the incrementing digit is giving me headaches.</p>
  
  <p>Anyone have any ideas  on how to do this?</p>