asked on collate Latin1_General_CI_AI - select distinct from MSSQL Table
Hello,
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!
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!
ASPMicrosoft SQL Server 2008
Last Comment
Nico2011
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks!
this however also means that you need to "catch" and handle all the values that are NOT yet in that table on a daily basis.
there is not "magic" solution for this; though you migth check out SOUNDEX() function to see if it would help