title: SQL Server - collation - difference between Latin1_General_CI_AS and Latin1_General_CS_AS
body: <p>How can I see the difference between </p>
  
  <pre><code>SELECT * 
  FROM (VALUES ('A'),('B'),('Y'),('Z'), ('a'),('b'),('y'),('z')) V(C)
  ORDER BY C COLLATE Latin1_General_CS_AS
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT * 
  FROM (VALUES ('A'),('B'),('Y'),('Z'), ('a'),('b'),('y'),('z')) V(C)
  ORDER BY C COLLATE Latin1_General_CI_AS
  </code></pre>
  
  <p>?. For this set of characters there is no difference.</p>
  
  <p>Cheers
  Bartosz</p>