try:

Select trim(field1)||trim(field2)||trim(field3)
From TableName

crizoo4712 wrote:

> The concatenatin problem is obviously a bug.
> i have a field varchar(2056).
> i have anaother field varchar(10) default '1234567890'.
> i concatenate it to the first field.
> i also control the length of the concatenation-result.
> as soon as i come beyond the length of 255 (!) i get the error 'string
> truncation'.
> this is ovbiously a bug.
> what could be a workaround?
> regards, christoph
>
>

[Non-text portions of this message have been removed]