At 08:04 PM 23/08/2007, you wrote:

>Helen Borrie wrote:
>
> > Trailing blanks supplied in inputs to varchar fields are not stored.
>
>Ah, I see! Thanks!
>
>Just out of curiosity: Is this in accordance with the (latest...?) SQL
>standard or doesn't the standard say anything about this?

I have no idea. There are as many variants as there are SQL
implementations, though, from what I can figure out. Oracle, for
example, has an extra VARCHAR2 type that retains trailing blanks...

./heLen