title: Simple like query in sql server return no result
body: <p>I've got a simple LIKE query on sql server that returns no result when the leading character is the same as the first...</p>
  
  <p>Database tale contains a row with the field 'Lastname' and the value 'Aalesund'</p>
  
  <pre><code>select * 
  from table 
  where LastName like 'A%' -- returns no results
  </code></pre>
  
  <p>if I change the 'Lastname' field to contain 'Alesund' the exact same query returns the correct row.</p>
  
  <p>Any ideas?</p>
  
  <p>Stig</p>