title: SSRS Comma-delimited list as Parameter value
body: <p>I have a report in SSRS. My parameter allows multiple values. My query has in the WHERE statement:</p>
  
  <pre><code>WHERE AllDiag IN (@Diag)
  </code></pre>
  
  <p>My user should be allowed to enter something like Z34.83,R30.0,0000.</p>
  
  <p>These are 3 different codes to search for, so technically it is looking for:</p>
  
  <pre><code>WHERE AllDiag IN ('Z34.83','R30.0','0000')
  </code></pre>
  
  <p>I've tried all kinds of things like making the parameter properties in the query properties an expression using <code>=join(Parameters!Diag.Value,"','")</code>, and even entering the list of codes with the quotes already, but nothing seems to allow this to work.</p>
  
  <p>I even tried some split function to see if it searched for each separately but I'm not sure I even use it right since there seems there might be some function that should run before.</p>
  
  <p>I'm out of ideas. Any help is greatly appreciated!</p>