At 10:08 PM 19/09/2007, you wrote:

>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?

OK, then lack of outer parens wasn't what it was complaining about
before. What does the monitor show when you apply the original
syntax but with the qualifier added to the operand?

Helen