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