title: Microsoft SQL Server treats leading and trailing whitespaces differently?
body: <p>I observe that sql is able to match a value like '4280 ' if matched for '4280' but it does not detect '    10442', when searched for 10442</p>
  
  <p>Please see the queries below</p>
  
  <pre><code>CREATE TABLE Persons
  (
  PersonID int,
  myval varchar(255),
  );
  
  select * from Persons
  
  insert into Persons values(1,'aftab')
  insert into Persons values(2,'    10442')
  insert into Persons values(3,'4280 ')
  
  /* It does not retrieve the row which has myal '10442' */
  select * from Persons where myval='10442'
  
  /* It does retrieve the row which has myal '4280' in spite of the trailing spaces*/
  select * from Persons where myval='4280'
  </code></pre>
  
  <p>I would have expected both the trailing and leading white spaces to be treated the same, ie, either '    10442' and '4280 ' are both detected, or both to be not detected.</p>