title: SQL in (@Variable) query
body: <p>I have the following code, the problem is that my variable list @LocationList is essentially a csv string.  When I use this as part of the where LocationID in (@LocationList) it says its not an int (LocationID is an int).  How can I get this csv string to be accepted by teh in clause?</p>
  
  <pre><code>Declare @LocationList varchar(1000)
  Set @LocationList = '1,32'
  
  select Locations from table where Where LocationID in (@LocationList)
  </code></pre>