title: Like Operator for checking multiple words
body: <p>I'm struggling for a <code>like</code> operator which works for below example</p>
  
  <p>Words could be</p>
  
  <pre><code>MS004 -- GTER   
  MS006 -- ATLT   
  MS009 -- STRR   
  MS014 -- GTEE   
  MS015 -- ATLT
  </code></pre>
  
  <p>What would be the like operator in <code>Sql Server</code> for pulling data which will contain words like <code>ms004 and ATLT</code> or any other combination like above.</p>
  
  <p>I tried using multiple like for example</p>
  
  <pre><code>where column like '%ms004 | atl%' 
  </code></pre>
  
  <p>but it didn't work.</p>
  
  <p><strong>EDIT</strong> </p>
  
  <p>Result should be combination of both words only.</p>