title: LIKE with integers, in SQL
body: <p><strong>Can I replace</strong> the  <code>=</code>  statement with the <code>LIKE</code> one for the integers <strong>?</strong></p>
  
  <p>by eg. are the following the same thing:</p>
  
  <pre><code>select * from FOOS where FOOID like 2    
  // and 
  select * from FOOS where FOOID = 2
  </code></pre>
  
  <p>I'd prefer to use <code>LIKE</code> instead of <code>=</code> because I could use <code>%</code> when I have no filter for FOOID...</p>
  
  <p>SQL Server 2005.</p>
  
  <p><strong>EDIT 1 @Martin</strong><br>
  <img src="https://i.stack.imgur.com/gBlYC.jpg" alt="enter image description here"></p>