sort order

A sort order is a set of definitions that specify how the SQL Server will organize and present data as a result of database queries. The sort order determines how the SQL Server will handle the collation of characters for both data storage and data retrieval operations involving the GROUP BY, ORDER BY, and DISTINCT statements. The SQL Server also uses the underlying sort order to resolve queries involving the WHERE and DISTINCT statements.