title: Compare Id from a Comma separated value in Sql Server
body: <p>I have a column in which UserIds are stored in a comma separated form (as shown below). Now I have a problem that I need to check whether the current user is available in that list or not. </p>
  
  <pre><code>Id     UserId 
  --  ---------------
  1    10,11,12,13    
  2    10,13,15,4     
  </code></pre>
  
  <p>I have used split function for this but that was taking too much time because I have millions of records and having 20 other columns. </p>