How do a set the field width in a select statement. I'm probably being particularly obtuse this morning, but I can't find it in the docs.

fld1 & fld2 are character fields
myfunc returns a variable length string

select fld1, myfunc( fld2 ) as myfld2, 123 as newfld3 from .......

I want myfld2 to be 120 chars & newfld3 to be numeric width 5 no dp.

Any help would be appreciated.