Re: I am trying to update an oracle table with a numeric value wh ich needs to be eight positions. No ma

["Jason Sekkes (SB)" <Jason.Sekkes@STROEHMANN.COM>]

If the field in Oracle is numeric you will not be able to get leading zeros
without editing the field when selecting it or changing the table definition
to alpha numeric.

Jason Sekkes
Programmer Analyst
Stroehmann Bakeries, LC
* (610)-631-8214
* Jason.Sekkes@Stroehmann.com


-----Original Message-----
From: Charllotte Hurt [mailto:CHurt@YAR.MIRACOSTA.CC.CA.US]
Sent: Thursday, July 12, 2001 12:30 PM
To: SQR-USERS@list.iex.net
Subject: I am trying to update an oracle table with a numeric value
which needs to be eight positions. No ma


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.