In this case code in EXE doesn't work in (IBO 4.6B components)...I haven't result when names ending with diacritic characters or when they have diacritic in the midle of the name...I don't use IBO_Search component...

qrMembers.SQL.Clear;

qrMembers.SQL.Add(FMemberSQL + ' and UPPER("Person"."LastName")
starting with UPPER(:SEARCH_CRITERIA);');

qrMembers.ParamByName('SEARCH_CRITERIA').AsString :=
TrimRight(AnsiUpperCase(edSEARCH.Text));

qrMembers.Close;
qrMembers.Open;


But this work with diacritic in IBExpert:


select * from "Person"
where
UPPER("Person"."LastName") starting with UPPER( :SEARCH_CRITERIA )