1 Level 1 1.1 Level 2 1.1.1 Level 3 1.1.1.1 Level 4 *My table contain these fields: ID_Level Name_Level 1 Level 1 11 level 2 111 Level 3 1111 Level 4>Frederico, you do not say what format you want the output to be when the value is 22? If you want leading zero's or spaces then you can try:
> >nAccount = 22 > >* This will output 00.00.00.022 >? PADL( TRANSFORM( nAccount ), 12, "0" ) PICTURE "99.99.99.999" > >* This will output . . . 22 >? PADL( TRANSFORM( nAccount ), 12, " " ) PICTURE "99.99.99.999" > >>