title: Simplifying WHERE clause
body: <p>Is there a way to simplify this WHERE statement so one only has to declare the Airport and StoreName once and let the category and fixture vary?</p>
  
  <pre><code>SELECT * FROM  Product_Display
  WHERE (Airport = 'JFK' AND StoreName = 'T3' AND Category = 'Pralines' AND FIXTURE like '%W15%') 
  OR (Airport = 'JFK' AND StoreName = 'T3' AND Category = 'Kinder' AND FIXTURE like '%W12%') 
  OR (Airport = 'JFK' AND StoreName = 'T3' AND Category = 'Nutella' AND FIXTURE like '%G04%') 
  OR (Airport = 'JFK' AND StoreName = 'T3' AND Category = 'Tic Tac' AND FIXTURE like '%W12%')
  </code></pre>