Hi Stuart,

When you build your string, use Transform to pad the left of the numeric field with zeroes i.e. TRANSFORM(nMyNumeric, "@L 99999.99")

HTH,
Arriyel

>I have table as follows:
>
>port c(1)
>agent c(3)
>cost n(8,2)
>
>I want to be able to zero file the cost field so that when i copy the details
>to a file it looks as follows:
>
>"P1","Z10",00012.78
>
>How can i zero fill this numeric field? If I change it to character and zero fill it the output looks as follows:
>
>"P1","Z10","00012.78"
>
>I can't remove the quotes cause then the first two fields do not have quotes
>and I need these to have quotes.
>
>Is there some way than you can format the numeric field to be zero filled?
>
>I would really appreciat some help.
>
>Regards,
>
>Stuart