Hi Pete

Did you try something like:

name LIKE 'new%k%'

IB/FB does not understand the '*', so perhaps IBO is replacing it somehere.
(I'm just arguing, not sure about this).

Artur

----- Original Message -----
From: "petegajria" <petegajria@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, June 25, 2002 10:46 PM
Subject: [IBO] filter problem


> Hi,
> I'm running into an issue with filters when used in
> TIBO_Query
>
> the sql returns data from the states table eg name & code
>
> so when i apply a filter like this
> 'name = new*'
> it correctly returns new mexico & new york
> but when i do new*k it fails
> as does *york etc etc
>
> anyone have a workable solution
> if so please post an example.
>
> thanks
> pete
>
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>