I use TIBOQuery / TDataSource / TIB_Monitor objects. The full code is
next:

dbnominas->SQL->Clear();
dbnominas->SQL->Add ( "select......" );
dbnominas->Open();
.
.
.
Then filter it
.
.
.
dbnominas->Filtered = false;
dbnominas->Filter = "lefts(destcon,2) = rights('" + ( AnsiString )
dbcentro->FieldValues["centro"] + "',2) ";
dbnominas->Filtered = true;
.
.
.
Also, I used to manage lefts and rights UDF functions (extract from
ibphoenix I think).

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 09:22 AM 7/12/2004 +0000, you wrote:
>
>
> >Hi,
> >
> >I've a TIBQuery with a query that runs ok.
>
> [big snip]
>
>
> >The where clausule isn't correct, and I don't know why!! Any idea?
>
> Because it doesn't use legal SQL elements.
> But first, are you really using TIBQuery? If so, you are not using IB
> Objects, but InterBaseXpress.
>
> Please confirm. We don't do IBX support on this list.
>
> Helen