title: SQL Select DISTINCT with WHERE LIKE
body: <p>I am trying to select distinct BILLCOMPANY from a table with a where BILLCOMPANY like 'value' however it's returning all matches not just distinct.</p>
  
  <p>Suggestions? </p>
  
  <pre><code>SELECT DISTINCT BillCompany,  UniqueID
  From Customer
  WHERE BillCompany LIKE  &lt;cfqueryparam value="%#URL.term#%" cfsqltype="cf_sql_varchar"&gt;
  </code></pre>
  
  <p>Sample Data<br>
  UniqueID / SiteCompany   /  BillingCompany<br>
  1     /    McDonalds-213 / ABC Management<br>
  2     /    McDonalds-215 /  XYZ Company<br>
  3    /    McDonalds-817  / ABC Management<br>
  4     /    Burger King-6 /  XYZ Company<br>
  5     /    Dairy Queen-7 /  Billy Bob Corp<br>
  6     /    KFC-4857   /    ABC Management<br></p>
  
  <p>In the end I need a list:<br>
  ABC Management<br>
  XYZ Company<br>
  Billy Bob Corp<br></p>
  
  <p>UniqueID is going to be used later to pull the rest of the billing address. </p>