At 10:51 AM 7/12/2004 +0000, you wrote:

>Hi
>
>I use a TIB_Cursor to locate a record in a tabel.
>The return values I have found out how to avoid trimming (through the
>FIELDSTRIMMING).
>
>But I would like to do the same with a parameter passed to the SQL.

If you are using Firebird 1.5 and the fields are varchar, then you don't
need to. They come through right-trimmed.

With char fields, you would need to use a UDF like rtrim.

H.