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
Stuart Reid
True nobility lies not in being superior to another man, but in being superior to one’s previous self