Re: trailing spaces

Hi,

Hy,

I have a table with a field created as char(400). For some reason, when
I insert information into this, trailing spaces are automatically added
so that select char_length(fieldname) always gives 400.

How can I amend this table column so that I don't have to use "select
trim(trailing from fieldname);" to get a well formatted result?

Don't use char(400) use varchar(400).

Thanks

Ale

Diana