danish_orthography.sql

DECLARE @places TABLE (name nvarchar(max));

insert into @places(name) values('Aarhus');
insert into @places(name) values('Berlin');
insert into @places(name) values('Zurich');
insert into @places(name) values('Aachen');

select name from @places order by name COLLATE Latin1_General_CI_AI
select name from @places order by name COLLATE Danish_Norwegian_CI_AI
select name from @places order by name COLLATE Finnish_Swedish_CI_AI