I am trying to format a decimal field to get the commas displayed using: CAST((( SAUP) (FORMAT 'ZZ,ZZZ,ZZ9.99')) AS CHAR(13))) (NAMED VALUE1), which works but now I want to right justify the data as if it were an integer field. I cannot find any functions or command to right justify this character data. Please help. Thank you.
I have an integer value that I want to right justify. anybody know how to do that? using lpad means i have to cast the integer value to char, and doing that removes some of the numbers (leaves only the first character)
say i have a value: '22' and the max value for that field is 5 integers. I would need it to come out as:
blankspaceblankspaceblankspace22 -> total of 5 characters ( 22)
I would need that since I will be appending quotes before and after the value such that the end result will be: " 22"