This contact picker by J. Young uses the UPPER function to avoid capitalisation-related issues in the search. In Canadian French, UPPER doesn't remove the accent (we accentuate caps) so é becomes É. Sometimes people will enter their names with or without the accent, depending of the person who logs the info, or the input system limitations etc. So sometimes my name is Cécile and sometimes I figure as Cecile in certain databases.
SQL isn't forgiving; if you put the accent in the search it won't find Cecile and if you don't put it, it won't find Cécile.
How can the statement be altered to compare only apples with apples?