SQL SERVER – Understanding how MIN(text) works
It’s determined by the collation (sort order). For most cultures the collation order is the same as the alphabetical order in the English alphabet so: ‘AA’ < ‘AB’ ‘AA’ < ‘AC’ ‘AB’ < ‘AC’ Therefore ‘AA’ is the minimum value. For other cultures this may not hold. For example a Danish collation would return ‘AB’ … Read more