ms-accessvbams-access-2013

Accent-insensitive query in MS Access 2013

Looking for an MS Access 2013 query that would treat Gutiérrez and Gutierrez as being equivalent strings.

Solution

  • This query uses a LIKE clause with a character range to match both names:

    SELECT ID, LastName
FROM Table1
WHERE LastName LIKE 'Guti[e,é]rrez';

    Unfortunately, the Access Database Engine does not support accent-insensitive collation like SQL Server does, so tweaking the "database sort order" of the Access database won't help.