sorted collation

Sorted data in tables in SQL Server using COLLATE clause

The COLLATE is a clause apply to the database, column or string expression, set collation for data. The COLLATE clause inher ... RDER BY name COLLATE Polish_CI_AI BIN : SELECT[id],[name] FROM [BazaTest].[dbo].[person] ORDER BY name COLLATE Polish_BIN