OK, thanks very much for your help :-)

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
> --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
> wrote:
> > >
> > > Hi, is there a way to remove trailing spaces from a varchar,
> preferably
> > > using a trigger?
> > >
> > > For example:
> > >
> > > ID = 'XYZ ';
> > >
> > > should be converted to: ID = 'XYZ';
> > >
> > > Are there any functions for doing this?
> > >
> > > Thanks
> > >
> >
> > F_STRIPSTRING works for me. It's in the FreeUDFLib
> > Alan
>
> Even easier, IB_UDF is included in the default firebird install
>
> DECLARE EXTERNAL FUNCTION rtrim
> CSTRING(255)
> RETURNS CSTRING(255) FREE_IT
> ENTRY_POINT 'IB_UDF_rtrim' MODULE_NAME 'ib_udf';
>
> A simple
>
> BEFORE INSERT OR UPDATE
>
> trigger could have the single line
>
> NEW.ID = rtrim(NEW.ID);
>
> But consider using generators and bigint for primary key fields. I
> imagine quite a lot of confusion could happen if the client program
> thinks it knows the real primary key but in reality you have changed
> it. It may end up with a foreign key violation when it tries to use
> the string it thinks is the PK in another table.
>
> Adam