>>>Hi, I have outputted some data to a file for use in a report but the price figure do not align properly and want to know a work around.
>>>LIST off job_nbr,' ',ALLTRIM(STR(price,10,2)),' ',ALLTRIM(STR(old_price,10,2)),' ',todaydt for g>1
>>>but ends up looking like this depending on length of price value.
>>>
>>>13T001 7.00 6.00 09/15/08
>>>14T001 137.00 6.00 09/15/08
>>>15T001 9.00 6.00 09/15/08
>>>16T001 2.00 6.00 09/15/08
>>
>>Well, you just need to use PADR function instead of ALLTRIM(STR( to padr to the number of chars your want and align properly.
>>
>>LIST off job_nbr,' ',PADR(price,10),' ',PADR(old_price,10,),' ',todaydt for g>1
>
>Ah yes thanks. I just never bothered with that function(til now)

I was also thinking that perhaps you just need to remove ALLTRIM() from your statement. The result would be the same.