collate Latin1_General_CI_AI - select distinct from MSSQL Table
Posted on 2012-12-28
Is there a way to select 'distinct' region names with foreign characters please? I am looking to create a list of regions and am trying to avoid getting duplicates if they are wrongly typed in, or if they have foreign characters, for example, one user might have added a property in the 'Cote d'Azur' and another may have added a property in 'Cóte d'Azur' - with an accent on the 'o', but Idon't want to list *both* regions in my list as they are essentially the same region...
Thanks in advance for your help!