convert accentuated characters to none accentuated

[mathieu]

Hi,

I want to select rows without taking account of the accentuated characters. The aim of this is to get the results in a search engine, even if the user forgets to put an accent, or put an accent where he should not.

For example, I have a field with the value "publicité" , I want to get this result even if the user searchs the word "publicite".
I can't simply use a REPLACE(), because, this problem occurs with any kind of accentuated character (é,è,à,ô,â,etc), so I would have to nest a lot of REPLACE functions and I fear the query would be big enough. Do you know if there is a better way to do that ?