How can we store the values in the DB

Greenhorn

Posts: 10

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi All,

How can we store the value in the Data Base with the 0's in the before the number.

Ex:I have a number in the Db with value 36 , I want that value to be stored as 00036 in the DB.Can any one help me to do that.

Thanks in Advance,

Mastan.

Ulf Dittmer

Rancher

Posts: 43081

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Numbers don't have leading zeros, so the only option would be to store them as datatype varchar.

S J Martin

Greenhorn

Posts: 23

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Or, ...
Store them as the value that they are and worry about rendering where it matters. ;-)

Never attribute to malice that which is easily explained by incompetence.<br />SCJP (1.5)

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?