I'm trying to create a ASP script right now that will search a database for first and last name and see if there is a person in the database that has the first name + last name.

The twist is I'm working with variations of letters. So it may have a á in the name but if I search for a it should pick that up also.

So lets say we have the word página. If I search for pagina the word página will be a match. I'm hoping there is something simple like a sql command. But I don't think there is so I've thought of functions equilivent to PHP's preg and ereg.

Any help would be appreciated.

Thank you