title: SQL ending in multiple values
body: <p>Below line from this <a href="https://stackoverflow.com/questions/15324012/sql-how-to-select-words-with-certain-values-at-the-end-of-word">page</a> shows how to match based upon end characters.</p>
  
  <pre><code>select * from table where Name like '%es'
  </code></pre>
  
  <p>How could I modify the code if I want to match with multiple values. For example I have another table <code>T2</code> that has column <code>C1</code> and I want all values from column <code>Name</code> that end in values from column <code>C1</code></p>
  
  <p>if I want to find all Names that are in <code>C1</code>, I would use</p>
  
  <pre><code> select * from table where Name in (select C1 from T2)
  </code></pre>
  
  <p>on a similar lines I want something like below. It is a pseudo code</p>
  
  <pre><code>  select * from table where Name like (select '%C1' from T2)
  </code></pre>
  
  <p>Column <code>C1</code> and <code>Name</code> have thousands of values in them</p>