title: SQL SERVER - Understanding how MIN(text) works
body: <p>I'm doing a little digging and looking for a explanation on how SQL server evaluates <code>MIN(Varchar)</code>. </p>
  
  <p>I found this remark in BOL: MIN finds the lowest value in the collating sequence defined in the underlying database</p>
  
  <p>So if I have a table that has one row with the following values: </p>
  
  <pre><code>Data
  
  AA
  AB
  AC
  </code></pre>
  
  <p>Doing a <code>SELECT MIN(DATA)</code> would return back AA. I just want to understand the why behind this and understand the BOL a little better. </p>
  
  <p>Thanks! </p>