title: Query a table to find records with given text
body: <p>I have below 3 records in my table(<strong>TAG_DATA</strong>) column(<strong>TAGS</strong>).</p>
  
  <pre><code>car,bus,van
  bus,car,ship,van
  ship
  </code></pre>
  
  <p>I wrote a query to get records which has <code>car</code> and <code>bus</code> as below.</p>
  
  <pre><code>SELECT * FROM TAG_DATA
    where TAGS like '%car, bus%'
  </code></pre>
  
  <p>But above query return only below record.</p>
  
  <pre><code>car,bus,van
  </code></pre>
  
  <p>But i need to get output as below. because both records have <code>car</code> and <code>bus</code></p>
  
  <pre><code>car,bus,van
  bus,car,ship,van
  </code></pre>
  
  <p>How can i write a query for this ? I'm using MS SQL Server.</p>
  
  <p><strong>UPDATED</strong></p>
  
  <p>I'm selecting tags from multi select combobox in my application. so i need to give text in that. so can't use <code>and</code>/ <code>or</code> in my query.</p>