<div>
to cover &quot;all&quot; typos, you need to have a table that does cover the typos, and gives the correct alternative, and you return that value.<br />
this however also means that you need to &quot;catch&quot; and handle all the values that are NOT yet in that table on a daily basis.<br />
there is not &quot;magic&quot; solution for this; though you migth check out SOUNDEX() function to see if it would help
</div>


to cover "all" typos, you need to have a table that does cover the typos, and gives the correct alternative, and you return that value.
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

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Is there a way to select 'distinct' region names with foreign characters please? &nbsp;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...<br />
<br />
Thanks in advance for your help!
</div>
</div>


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!

collate Latin1_General_CI_AI - select distinct from MSSQL Table

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.