title: SQL Server 2005 : using OR operator with LIKE operator
body: <p>How can I use <code>LIKE</code> operator with the <code>OR</code> operator in SQL Server 2005? For example:</p>
  
  <pre><code>SELECT * 
    FROM table 
   WHERE column_name LIKE '%boo%' OR '%bar%' 
  </code></pre>
  
  <p>This does not seems to work !</p>
  
  <p><strong>EDIT 1</strong> : RESPONSE TO FIRST ANSWER POSTED:</p>
  
  <p>Cool, that works ! but I just found for the first time that your order conditions do not work with like ... I want to ask is this normal or am I making a mistake? please see below to see what I mean</p>
  
  <pre><code>select * 
  from &lt;table&gt; 
  where col_name = 'VAL-QWE' 
        AND scenario like '%xxx%'
        OR scenario like '%yyy%'
  </code></pre>
  
  <p>if you execute this query, sql server does not cares for <code>col_name = 'VAL-QWE'</code>  condition at all, it just looks at the like condition ?</p>