Hi,

> And I'd like to have a result with spaces filling the field_1 when null

select cast(coalesce(FIELD_1,'') as char(20)) || FIELD_2
from TEST_TABLE;


HTH

Regards,
Anderson Farias