Subject RE: [firebird-support] Removing trailing spaces from varchar
Author Bc. Jirí Cincura
yaedos2000 wrote (on Friday, July 29, 2005 12:11 PM):
> 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?

I think there's UDF in FB distribution with ltrim, rtrim, ... functions.

It's originally from IB, but it should work (because it's in distribution)

Bc. Jirí Cincura
ICQ: 314711544; Yahoo!: x2develop