title: SQL Multiple LIKE Statements
body: <p>I'm currently working on a report that shows me all postcodes covered by our sales team.</p>
  <p>Each team covers over 100 postcodes. What I would like to do is create a report that brings back the clients within the postcode. Currently, my code looks like this.</p>
  <pre><code>SELECT * FROM tbl_ClientFile
   WHERE CLNTPOST1 LIKE ('B79%')
    OR CLNTPOST1 LIKE ('BB1%')
    OR CLNTPOST1 LIKE ('BB10%')
    OR CLNTPOST1 LIKE ('BB11%')
    OR CLNTPOST1 LIKE ('BB12%')
    OR CLNTPOST1 LIKE ('BB18%')
    OR CLNTPOST1 LIKE ('BB2%')
    OR CLNTPOST1 LIKE ('BB3%')
    OR CLNTPOST1 LIKE ('BB4%')
    OR CLNTPOST1 LIKE ('BB5%')
    OR CLNTPOST1 LIKE ('BB6%')
    OR CLNTPOST1 LIKE ('BB8%')
    OR CLNTPOST1 LIKE ('BB9%')
    OR CLNTPOST1 LIKE ('BB94%')
    OR CLNTPOST1 LIKE ('BD1%')
    OR CLNTPOST1 LIKE ('BD10%')
    OR CLNTPOST1 LIKE ('BD11%')
    OR CLNTPOST1 LIKE ('BD12%')
    OR CLNTPOST1 LIKE ('BD13%')
    OR CLNTPOST1 LIKE ('BD14%')
    OR CLNTPOST1 LIKE ('BD15%')
    OR CLNTPOST1 LIKE ('BD16%')
    OR CLNTPOST1 LIKE ('BD17%')
    OR CLNTPOST1 LIKE ('BD18%')
    OR CLNTPOST1 LIKE ('BD19%')
    OR CLNTPOST1 LIKE ('BD2%')
    OR CLNTPOST1 LIKE ('BD20%')
    OR CLNTPOST1 LIKE ('BD21%')
    OR CLNTPOST1 LIKE ('BD22%')
    OR CLNTPOST1 LIKE ('BD3%')
    OR CLNTPOST1 LIKE ('BD4%')
    OR CLNTPOST1 LIKE ('BD5%')
    OR CLNTPOST1 LIKE ('BD6%')
  </code></pre>
  <p>What I was hoping for is that there is a faster and easier way of doing this. Any suggestions would be greatly appreciated. Is there a way to create a variable for each sales Team like <code>@SalesTeam1 = SELECT * FROM tbl_ClientFile WHERE POSTCODE1 like '' or like ''</code></p>
  <p>Just fishing for ideas really. Cheers</p>