title: Select query without exact match using % Wildcard
body: <p>Hello I have almost solved a problem here and I need help, by using this code</p>
  
  <pre><code>SELECT *
  FROM  new_products
  WHERE 
  NOT EXISTS
  (
    SELECT ProductID
    FROM old_products
    WHERE 
           old_products.ProductID
           LIKE
           new_products.ProductID
  )
  </code></pre>
  
  <p>This is supose to bring me the items from new_products that are not on old_products (just the new products to be selected).</p>
  
  <p>However when the product id varchar is like '91 or 91b' it is not found, only if in both tables they are the <strong>exact same</strong> varchar.</p>
  
  <p>I tried using something like (like %ProductID%) doing by this:</p>
  
  <pre><code>    WHERE 
             old_products.ProductID 
             LIKE 
             ('%' + new_products.ProductID + '%')
  </code></pre>
  
  <p>However the results are not working at all, it considers item that are in both as unique and vice versa. Any help ?</p>