Probably I do not understand something, but I said you should use 2 functions char AND rtrim
First will convert to character with possible trailing spaces, the second will remove them

regards,
dmitri