The sort order chosen for a server determines the order in which SQL Server sorts data in response to queries, as well as the results that SQL Server returns for queries that involve character comparisons.
For information, choose one of these topics:
Dictionary Order, Case-insensitive
Dictionary Order, Case-sensitive
Dictionary Order, Case-insensitive, Uppercase Preference
Dictionary Order, Case-insensitive, Accent-insensitive
Additional Sort Orders for Code Page 850