title: Using a comma-separated parameter in an IN clause
body: <p>I have <code>'param1, param2, parma3'</code> coming from SSRS to a stored procedure as a <code>varchar</code> parameter: I need to use it in a query's <code>IN</code> clause but then need to change its format like this first:</p>
  
  <pre><code>select *
  from table1
  where col1 in('param1', 'param2', 'param3')
  </code></pre>
  
  <p>What is the best way to reformat the parameter without creating functions and parameter tables?</p>