At 11:06 AM 7/12/2004 +0000, you wrote:

>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).

If you have these UDFs and you know that they work, then that is no
problem, syntactically. But it's the second argument that is your problem
here. It is not a valid expression.

Helen