title: SQL Server IN with multiple values as a parameter
body: <p>I have a SP as below (example only) and want to filter the City based on values passed in as a parameter.</p>
  
  <pre><code>SELECT * FROM Customers
  WHERE City IN (@cities_as_a_parameter);
  </code></pre>
  
  <p>In my C# code, I have the below </p>
  
  <pre><code>cmd.Connection = con;
  cmd.CommandType = System.Data.CommandType.StoredProcedure;
  cmd.CommandText = "MY_SPNAME";
  cmd.Parameters.AddWithValue("@cities_as_a_parameter", "'Paris','London', 'xxx', 'yyyy'");
  </code></pre>
  
  <p>My question is how to pass multiple values to the SP parameter @cities_as_a_parameter ? Above code does not work and want to know what is the correct way of doing this.</p>
  
  <p>What is the best way to do this ? </p>
  
  <p>OR is there any other way to do this (without using multiple where conditions)? </p>