>Thank you ahead for helping me with this simple question.
>
>I have a query in which I am reformatting fields from a table and building an All Text file. I am looking for a function or expression that I can place in the output field that will zerofill the leftmost positions of the character output.
>
>I am currently using str(penaltyamt,9,2) to get a nine character field with decimal places.
>ex.
>" 900.00"=STR(pnlty_amt,9,2)
>This, as you know does not give me leading zeroes. Is there a function to accomplish this?
Try
TRANSFORM(pnlty_amt, "@L 999999.99")
--sb--