title: Find whole value without using LIKE operator
body: <p>I have a large number to find in a table. But only a little part of it is given to me to find the whole number. I am looking for some new way to find these out without using the <code>like</code> operator. I know it is a simple thing, but I need a new approach.</p>
  
  <ul>
  <li>Value given is:  <code>4213076600</code></li>
  <li>Value to find is:  <code>89013106904213076600</code> </li>
  </ul>
  
  <p>I want to find it in the following query: </p>
  
  <pre><code>SELECT  * 
  FROM    table_name 
  WHERE   column_name in (value,value,value) 
  </code></pre>
  
  <p>i have searched the websites for this and came to know about the left() and right() functions but don't know how to arrange them to get the result </p>