title: WHERE clause on VARCHAR column seems to operate as a LIKE
body: <p>I've stumbled across a situation I've never seen before. I hope that someone can explain the following.</p>
  
  <p>I've ran the following query, hoping to get only the results of columns whoes value is exactly equal to <code>1101</code></p>
  
  <pre><code>select '--' + MyColumn + '--' SeeSpaces, Len(MyColumn) as LengthOfColumn 
  from MyTable 
  where MyColumn = '1101'
  </code></pre>
  
  <p>However, I also see values where <code>1101</code> is followed by (what I believe are) spaces.</p>
  
  <p>So <code>SeeSpaces</code> returns </p>
  
  <pre><code>--1101&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;--
  </code></pre>
  
  <p>And <code>LengthOfColumn</code> returns <code>4</code></p>
  
  <p><code>MyColumn</code> is a <code>VARCHAR(8), NOT NULL</code> column. Its values (including the spaces) are inserted through a separate workflow. </p>
  
  <p>Why does this select not return only the exact results?</p>
  
  <p>Thanks in advance</p>