Hi Leonard,
I don't think there is any way of storing leading zeros in number datatype in the database. While retrieving it however you can do so by using the format Shestakov specified. I would prefer keeping the field as a char/varchar2 type!
Thanks,
-Shyami




Reply With Quote