title: Set variable value to array of strings
body: <p>I want to set a variable as a string of values. E.g.</p>
  
  <pre><code>declare @FirstName char(100)
  select @FirstName = 'John','Sarah','George'
  
  SELECT * 
  FROM Accounts
  WHERE FirstName in (@FirstName)
  </code></pre>
  
  <p>I'm getting a syntax error in the line <code>select @FirstName = 'John','Sarah','George'</code>:</p>
  
  <pre><code>Incorrect syntax near ','
  </code></pre>
  
  <p>Is there any way I can set the variable with many values?</p>