title: FIND_IN_SET() equivalent in SQL Server
body: <pre><code>SELECT * FROM users WHERE uid IN (SELECT doctors FROM MainPage WHERE Valid=1)
  </code></pre>
  
  <blockquote>
    <p><code>users</code> table <code>uid INT</code>
    <br><code>Mainpage</code> table <code>doctors text</code> with value as <code>1,2,3,4,5</code></p>
  </blockquote>
  
  <p>When I am running the above query, it is only resulting 1 row which is for uid = 1, however I wanted all the 5 rows. So in MySQL I used this query:</p>
  
  <pre><code>SELECT *
  FROM users
  JOIN MainPage ON FIND_IN_SET(uid, doctors)
  WHERE Valid = 1;
  </code></pre>
  
  <p>It worked. I am trying to find an equivalent in SQL Server for <code>FIND_IN_SET</code> to achieve the same result ? </p>