title: Check sql table for values in another table
body: <p>If I have the following data:</p>
  <h3>Results Table</h3>
  <pre><code>.[Required]
  I want one grape
  I want one orange
  I want one apple
  I want one carrot
  I want one watermelon
  </code></pre>
  <h3>Fruit Table</h3>
  <pre><code>.[Name]
  grape
  orange
  apple
  </code></pre>
  <p>What I want to do is essentially say give me all results where users are looking for a fruit. This is all just example, I am looking at a table with roughly 1 million records and a string field of 4000+ characters. I am expecting a somewhat slow result and I know that the table could DEFINITELY be structured better, but I have no control of that. Here is the query I would essentially have, but it doesn't seem to do what I want. It gives every record. And yes, <code>[#Fruit]</code> is a temp table.</p>
  <pre><code>SELECT * FROM  [Results]
  JOIN [#Fruit] ON
  '%'+[Results].[Required]+'%' LIKE [#Fruit].[Name]
  </code></pre>
  <p>Ideally my output should be the following 3 rows:</p>
  <pre><code>I want one grape
  I want one orange
  I want one apple
  </code></pre>