title: how to search and retrieve the matching word from a comma separated string in one column
body: <p>I have a problem with my <code>Bus</code> table which contain:</p>
  
  <pre><code>Bus_no(int)
  Bus_Route(Varchar)
  Bus_Stop(varchar)
  </code></pre>
  
  <p>My <code>Bus_Stop</code> column contains stop as comma separated string as given below:  </p>
  
  <pre><code>'Apsara,Shahadara,Shakarpur,Mother Dairy,Badarpur,'
  </code></pre>
  
  <p>I need to search for a particular word like <code>Shakarpur</code> without comma in <code>SQL Server</code>.</p>