title: Need to use COLLATION in a SELECT DISTINCT
body: <p>I am trying to apply collation on a SELECT DISTINCT statement. anyone now how to do this?</p>
  
  <p>One would think that the DISTINCT would detect upper and lower case as different, i.e..   'Yes' and 'YES'.</p>
  
  <p>But DISTINCT does not appear to be case sensitive. So I believe I need to add COLLATE...</p>
  
  <pre><code>SELECT DISTINCT COLLATE Latin1_General_CS_AS Shrt_Text AS  Sht_text
  FROM  tblMatStrings 
  </code></pre>
  
  <p>Any idea on how to distinguish upper and lower in a SELECT DISTINCT?</p>