SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table CollationTests (
	i int identity,
	v varchar(20) collate German_PhoneBook_CI_AI not null,

	index IX_CollationTests_v clustered (v),
	constraint PK_CollationTests primary key (i)
)


insert into CollationTests (v) values
('Hammer'),
('Hauser'),
('Häuser'),
('Haeuser')
;
4 rows affected

select * from CollationTests
where v > 'Ha'
order by v


i
v


3
Häuser

4
Haeuser

1
Hammer

2
Hauser


select * from CollationTests where v like 'Ha%' order by v


i
v


4
Haeuser

1
Hammer

2
Hauser