title: Use CHARINDEX to find Value in other column always returns 1 record
body: <p>I have a simple table with </p>
  
  <pre><code>Location, PartNo, LookupPart
  </code></pre>
  
  <p>I am trying to find the PartNo that exist in the lookupPart column. Kinda like an excel Vlookup except I need to approximate and do other calculation in SQL.</p>
  
  <p>I am using </p>
  
  <pre><code>    SELECT Part_No
      FROM Part_tbl 
      WHERE CHARINDEX(PartNo,LookupPart)&gt;0 
  </code></pre>
  
  <p>Both PartNo and LookupPart are a VARCHAR.</p>
  
  <p>I am getting 1 record returned. 
   However, If I use:</p>
  
  <pre><code>     SELECT Part_No
       FROM Part_tbl 
       WHERE CHARINDEX('538',LookupPart)&gt;0 
  </code></pre>
  
  <p>I get 10+ records that start or contain '538'</p>
  
  <p>What am I missing?</p>