title: SQL LIKE with no wildcards the same as '='?
body: <p>I know this is a pretty basic question, and I <em>think</em> I know the answer...but I'd like to confirm.</p>
  
  <p>Are these queries truly equivalent?</p>
  
  <pre><code>SELECT * FROM FOO WHERE BAR LIKE 'X'
  SELECT * FROM FOO WHERE BAR ='X'
  </code></pre>
  
  <p>Perhaps there is a performance overhead in using like with no wild cards? </p>
  
  <p>I have an app that optionally uses LIKE &amp; wild cards. The SP currently does the like and appends the wild cards -- I am thinking of just updating the query to use like but have the app append the wild cards as needed.</p>