Subject Re: [IBO] Search question
Author Svein Erling Tysvær
>I think I can solve it with : .... SQLWhereItems.Add ('UPPER (NAME) IN
>:NAME'); ???
Wrong.

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.

Set