1

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

ebhh2001
  • 2,034
  • 4
  • 18
  • 27
  • You're looking for `Option Compare`? See [Documentation.SO](http://stackoverflow.com/documentation/vba/3992/vba-option-keyword/13937/option-compare-binary-text-database#t=201703042022356956831). – Mathieu Guindon Mar 04 '17 at 20:23
  • @Mat'sMug - Sorry, but I don't see how Option Compare helps me (solves my problem). Or are you saying accent-insensitive string comparison is not possible? – ebhh2001 Mar 04 '17 at 20:36
  • http://stackoverflow.com/q/5747698/1188513 - set the database's *collation*, or use `StrComp`. – Mathieu Guindon Mar 04 '17 at 20:43

1 Answers1

3

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.

Gord Thompson
  • 116,920
  • 32
  • 215
  • 418