> SQLWhereItems.Add ('UPPER (NAME) LIKE :NAME');
>
> and then add the neccessary characters at the beginning and end of the name
> (I think it may be '%', but aint quite sure.
>

same effect like SQLWhereItems.Add ('UPPER (NAME) CONTAINING :NAME');

Harald