format Number 1

[angjbsca]

Hi How I can format a field with this value '6' to '06' in
as400 db2...

in .net would look like this format(field,'0#')

 

[BrianTyler]

I don't know about AS400 specifics, but you could try:

digits(dec(FIELD,2))

You will have to investigate overflow possibilities etc

 

[angjbsca]

Thanks a lot its work great....

 

[ddiamond]

Brian,

I always did this with the following trick:
substr(field+100,2)

I like your approach much better. I've just always feared the digits function.

- Dan