SQL SERVER - Understanding how MIN(text) works.

Posted by tmercer on Stack Overflow See other posts from Stack Overflow or by tmercer
Published on 2010-12-21T20:40:34Z Indexed on 2010/12/21 20:54 UTC
Read the original article Hit count: 275

Filed under:
|
|

I'm doing a little digging and looking for a explanation on how SQL server evaluates MIN(Varchar).

I found this remark in BOL: MIN finds the lowest value in the collating sequence defined in the underlying database

So if I have a table that has one row with the following values:

Data

AA
AB
AC

Doing a SELECT MIN(DATA) would return back AA. I just want to understand the why behind this and understand the BOL a little better.

Thanks!

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about tsql