title: Strange behaviour of SQL order by when the string consists space
body: <p>SQL Example 1:</p>
  
  <pre><code>SELECT TestField 
  FROM (VALUES('Ne'), ('NE')) AS TestTable(TestField)
  ORDER BY TestField COLLATE Latin1_General_CS_AS
  </code></pre>
  
  <p>Result 1:</p>
  
  <pre><code>Ne  
  NE
  </code></pre>
  
  <p>SQL Example 2 (between NE and a there are 2 spaces, while between Ne and a there is only 1):</p>
  
  <pre><code>SELECT TestField 
  FROM (VALUES('Ne a'), ('NE  a')) AS TestTable(TestField)
  ORDER BY TestField COLLATE Latin1_General_CS_AS
  </code></pre>
  
  <p>Result 2:</p>
  
  <pre><code>NE  a  
  Ne a
  </code></pre>
  
  <p>Can someone explain it?  </p>
  
  <p>Thanks</p>