You can not zero fill (left of the leading number) a numeric field.

Why do you need to zero fill?

Einar

>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