Nico Callewaert wrote:

>
> Hi,
>
> I changed the OnPrepare statement of the query like this :
>
> if CheckBox1.Checked then
> SQLWhereItems.Add ('UPPER (NAME) STARTING WITH :NAME');
> else
> SQLWhereItems.Add ('UPPER (NAME) CONTAINING :NAME');

CONTAINING is not case sensitive, so you will not need the UPPER here

> After the user selects another option, I do a InvalidateSQL, so I'm sure the

You should not need to call InvalidateSQL, because it´s a build in by the SearchEdit.

Did you have a look at the SearchingLinks.dpr in the Samples directory ?
Here you can see how to setup this stuff.


Harald