title: How to find out whether collation uses word sort or string sort?
body: <p><a href="https://stackoverflow.com/a/361059/14731">https://stackoverflow.com/a/361059/14731</a> discusses the differences between "word sort" and "string sort".</p>
  
  <p><strong>How does one query programmatically when an SQL Collation will use "word sort" vs "string sort"?</strong></p>
  
  <p>Corollary: Do all collations use "word sort" for Unicode strings and "string sort" for non-Unicode strings?</p>
  
  <pre><code>SELECT * from sys.fn_HelpCollations()
  WHERE name = 'SQL_Latin1_General_CP1_CI_AS'
  </code></pre>
  
  <p>provides a lot of details about the collation, but notice that it makes no mention of "word sort".</p>