SQL search question

Hi,

I have a table containing a column with City names. In some cases the
names utilize accented characters like Montréal. If I accept text from
a form, and try and match any city names like Montréal, the accent
causes problems. While the set [e,E] is easy to deal with with an
ILIKE compare, the set [é,É] is not so easy to deal with. They are not
naturally converted case-wise with ILIKE.

How to best setup a search like this? I don't want to populate my
table with every variation of accented character to find matches.

My only idea the moment is to create a mapping function that strips
accented characters from the input before searching... but that seems
rather harsh...

Any other ideas, maybe someone has encountered this and had some
success with Regex???

Any help appreciated.

Dave