I have built a small searchable employee directory in ColdFusion for my organization. I've come across a little snag in the search function.

Does anyone know how to do an accent INsensitive search? Is there a function in ColdFusion or in SQL to do this?

My users need to be able to search for something like "André" and get both "André" AND "Andre" in the results (and vice versa).

Note: This is not a full text search and I do not use Verity for this application.

Thanks.