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
http://www.ID3renamer.com/
ICQ: 314711544; Yahoo!: x2develop
http://photo.cincura.net/