crizoo4712 wrote:

> I have a field varchar(2056) an try to concatenate up to 20 values to
> it. Even though the sum of their length is smaller than 2056 i
> get "string truncation".
> what can i do?

Maybe the type of those you are concatenating is CHAR, so they are
padded with spaces. Try using TRIM (you might need to combine with CAST
to varchar) on them just before concatenation.

--
Milan Babuskov
http://www.guacosoft.com