MVSFORUMS.com

Celeste Locklin · Posted: Thu Jun 30, 2011 7:07 pm Post subject: Display decimal

my table field is defined as PMT_AMT DECIMAL(11,2)
when i select it, i want it to appear in my output formatted as 00000000000.00

i have tried cast(PMT_AMT) & get a hex display
digits(PMT_AMT) & get 0000000000000
decimal . . . & get a hex display

how can i do this?

thanks in advance

kolusu · Posted: Thu Jun 30, 2011 7:53 pm Post subject:

Celeste Locklin,

Did you try CHAR(PMT_AMT DECIMAL) ?

Kolusu

Celeste Locklin · Posted: Fri Jul 01, 2011 11:42 am Post subject:

brilliant ! but it turns out to be
CHAR(PMT_AMT) DECIMAL

000000412.80

now how do i suppress those leading zeros ? Wink

kolusu · Posted: Fri Jul 01, 2011 12:22 pm Post subject:

Celeste Locklin · Posted: Fri Jul 01, 2011 1:19 pm Post subject:

amazing.