I am trying to update an oracle table with a numeric value which needs to be eight positions. No ma

[Charllotte Hurt <CHurt@YAR.MIRACOSTA.CC.CA.US>]

I am trying to update an oracle table with a numeric value which needs to be 
eight positions.  No matter what I try the number is coming out without the 
leading zeros.  For example, the number should be 00001739, but the database 
says 1739 after my update using sqr.

Even in sql if I say update table-in-question set field-in-question = 00001739, 
the value comes out in the database as 1739.

(The field is defined in the database as numeric.  I'm selecting the number 
from the table and adding +1 to increment as I add records.)

Any help would be appreciated.  Thanks.