title: Conversion failed when converting the nvarchar value '6,7' to data type int
body: <p>I have a table in SQL Server 2008 R2 with a column of type <code>NVARCHAR</code> that stores list of transactions, comma separated, eg <code>6,4,1</code></p>
  
  <p>Question is: I want to do an <code>IN</code> clause that refers to the content of that column, say</p>
  
  <pre><code>SELECT * 
  FROM myTransactions t 
  INNER JOIN pCollections pc ON pc.transc = t.transc 
  WHERE t.idnt IN (pc.fields)
  </code></pre>
  
  <p>The column <code>pc.fields</code> stores content like '6,7'. Instead I get the error </p>
  
  <blockquote>
    <p>Conversion failed when converting the nvarchar value '6,7' to data type int. </p>
  </blockquote>
  
  <p>Anyone know a workaround?</p>