How to ignore accents in a query?

P

Patrick Levy

Hi

I'm trying to do a query in access 2000 that ignores accents in this search

for example: SELECT * FROM EMPLOYEES WHERE NOME = 'LUIZ'

and a like this brings me both LUIZ and LUÍS, althoug I can guarantee the
serach strings will not contain any accents, the database field "NOME" may
cointains strings with accents.

Obviosly if I use some replace function i have to considerate every accent
(ÁÀÉÍÓÚÉÇ etc.)

Any ideias?

TIA

Patrick
 
Top