title: SQL - How to check if item is in a list in a record
body: <p>I have have a column name MyRoles that contains a list of items (integers) stored in a field named UserRoles. I want to write a query that checks to see if a specific item is in the list. The list will look like this: "1,2,3" </p>
  
  <p>I can't use WHERE MyRoles </p>
  
  <p>What should the query look like?</p>
  
  <p>This is similar to what I am thinking: </p>
  
  <pre><code>SELECT *
  FROM MyTable
  WHERE MyRoles CONTAINS ('1')
  </code></pre>
  
  <p>The fact that no answer was easy to implement and would take me farther down an ugly road really makes clear that a normalized database is always the best bet.  </p>