1> Create Table myText (id int Identity(1, 1) Primary Key, Text1 nvarchar(50) Collate Latin1_General_BIN, Text2 nvarchar(50) Collate Latin1_General_CI_AI)
2> go
1> Insert Into myText(Text1, Text2) Values ('Müll', 'Müll')
2> go

(1 Zeilen betroffen)
1> select * From myText Where Text1 = 'Mull'
2> go
id          Text1                                              Text2

----------- -------------------------------------------------- -----------------
---------------------------------

(0 Zeilen betroffen)
1> select * From myText Where Text2 = 'Mull'
2> go
id          Text1                                              Text2

----------- -------------------------------------------------- -----------------
---------------------------------
         1 Müll                                               Müll


(1 Zeilen betroffen)
1>

Where Text1 = 'Mull' Collate Latin1_General_CI_AI