Quote Originally Posted by Clive Richmond View Post
There is one obvious way this can be solve and that is to switch the MS-SQL collate sequence to SQL_Latin1_General_CP1_CI_AS but this involve a reasonable amount of SQL scripting for a successful outcome.
You can go to SQL-manager and change the SQL-collate from just this one field. No scripting needed. I have a situation like this in one of my projects. It certainly has his drawbacks but it has been working for years.

You could also create a (calculated) field with the same content but a different collate.