Distinct clause ignores special characters

Ooh, don't use German_PhoneBook_CI_AI_WS, because it to do have a very special sorting algorithm

Better use an Acsend insensitive collation like SQL_Latin1_General_CP1_CI_AI

SELECT DISTINCT street
FROM
   (SELECT 'BAHNSTRASSE' AS street
    UNION ALL
    SELECT 'BAHNSTRAßE') AS Sub

SELECT DISTINCT street
FROM
   (SELECT 'BAHNSTRASSE' COLLATE SQL_Latin1_General_CP1_CI_AI AS street
    UNION ALL
    SELECT 'BAHNSTRAßE') AS Sub

---

Olaf Helper

[ Blog] [ Xing] [ MVP]