Paul Schmidt wrote:
...
I agree with your point, in the case of a VARCHAR it should remove
the whitespace at the right, by default and in the case of a CHAR
field, the default should be to return the field without trimming.
In both cases this should be user modifyable to some other form of
trimming.
...
---------------------------

Remember, even a VARCHAR may have trailing (significant) spaces. Any
trimming should be done only when explcitly asked for - IMnsHO.

Regards,
Aage J.