Hi Helen, thanks for your reply!

My sql statement is just like this:

SELECT XX.ID, XX.STATE, XX.CUSTOMER_NAME
FROM CUSTOMER_TABLE XX
WHERE XX.STATE = 'CA'

After this, I apply the filter. I put the parenthesis as you told
me, but IBO parsed a wrong sql statement.

My filter: (UPPER(XX.CUSTOMER_NAME) LIKE 'HELEN%')

So, when I apply the filter, I got this sql:

SELECT XX.ID, XX.STATE, XX.CUSTOMER_NAME
FROM CUSTOMER_TABLE XX
WHERE XX.STATE = 'CA'
AND (UPPER(XX.CUSTOMER_NAME) AND LIKE 'HELEN%')

What is wrong because there's an extra "and" in the middle. I think
the whole problem is located at TIB_Dataset.ProcessSQLWhereStrings,
but who knows?

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 03:16 AM 19/09/2007, you wrote:
> >Hi!
> >
> > Do someone know what's wrong with this filter expression?
> >
> > UPPER(CLIENT_NAME) LIKE 'JOHN%'
> >
> > IBO raises an error everytime asking for parenthesis... Very
strange.
> >
> > My configuration: D7 + F1.5 + IBO4.8.7
>
> Missing from your posting is the SELECT statement to which this
> filter is being appended. That actually matters...
>
> 1. Do you need to include a relation qualifier to CLIENT_NAME? (the
> relation name or relation alias that is used for that table in your
> SELECT statement).
>
> 2. Try putting parentheses right around the whole thing. Filters
> are appended to any existing WHERE clause so it's possible the
> revised WHERE clause needs to isolate the filter.
>
> 3. Put in a monitor dialog. It's an amazingly useful way to resolve
> "weird", "strange", etc.
>
> Helen
>