Set,

With the % characters, looks the same like the CONTAINING solution
fom Harald.

thanks, regards,

Nico
-----Oorspronkelijk bericht-----
Van: Svein Erling Tysvar [mailto:svein.erling.tysvaer@...]
Verzonden: vrijdag 23 maart 2001 11:03
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] Search question

>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

Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]