>In that case I would prefer using Cast(), instead of space. ie:
>

SELECT  NVL(t1.field1, CAST('' as c(10)) AS field1, ...
>

My bad.

I missed where Koen said his fields were memo fields until he mentioned it again later in the thread. After I saw that, I did advise him to cast them to a fixed size.

Good advice.