title: Declare multiple value variable in SQL
body: <p>I would like to write an IN statement when setting the <code>RECEIPTIDS</code> variable, so that I can pass multiple values in that format into my query. I have tried the following: </p>
  
  <pre><code>DECLARE @RECEIPTIDS VARCHAR(2000)
  SET @RECEIPTIDS = ('R00013','R00028')
  </code></pre>
  
  <p>However, I get the error:</p>
  
  <blockquote>
    <p>Incorrect syntax near ','.</p>
  </blockquote>