Quote Originally Posted by Evertjan Dondergoor View Post
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.
Evertjan, I aware you can do this but such a piecemeal approach isn’t practical in a production environment with hundreds of tables. And after all, the issue here is the DataFlex string comparison collating rules not matching that of the SQL database.