Subject Re: [IBO] Filter
Author Helen Borrie
At 11:54 PM 19/09/2007, you wrote:
>Hi, here goes the original SQL (with monitor output), after I aplied
>the filter:

I meant, apply the original filter (without the extra parens) but
with the qualifier correction.

So - apply the filter as

upper ( cli.NOME) LIKE 'TIAGO%'

You haven't said HOW you are applying the filter. Remember, it is a
string, so you need to take care of embedded quotes. So, if it's in
code and you are hard-coding the LIKE operand, you'll need to do e.g.

MyDataset.Filter := QuotedStr('upper ( cli.NOME) LIKE 'TIAGO%');

Helen