title: How can I JOIN two tables columns using a wildcard?
body: <p>I'm using Access 97.</p>
  
  <p>This is what I wanna do:</p>
  
  <pre><code>SELECT *
  FROM CodeDIS, ListOfProducts
  WHERE CodeDIS.IDNumber LIKE ListOfProducts.IDNumber*;
  </code></pre>
  
  <p>Sometimes the IDNumber on ListOfProducts has an extra letter indicating some information about the product. </p>
  
  <p>So I have the IDNumber AC244 on CodeDIS but I have AC244P on ListOfProducts. </p>
  
  <p>All I want is to add a wildcard to the end of the condition. </p>
  
  <p>Is this possible?</p>