Need to add digits in front of a number

[Neozero]

I am trying to populate a field with a 5 digit number and when the query runs, it only puts in a 4 digit number. For instance, I want a number to show up as 01457 when the query runs the number actually shows up as 1457. What can I do to make the 0 show up to make it a 5 digit number ? Here is the actual query I am using.

Select Max( EbClock ) + 1, Max( EbClock ) + 1 from Ebase where EbClock < ‘99000’

Any suggestions would be greatly appreciated.


[sig][/sig]

 

[carp]

What RDBMS are you using?
If you are using Oracle, you will not be able to store the number with the leading zeros. However, the problem is NOT how the data is stored internally - it's how you display it. For instance, you could store the value as a number, but when you want to display it, use
to_char(my_number,'00000') [sig][/sig]