how can I force leading zeros on an int type?

[hoggle]

I'm creating some new tables and I want to store leading zeros on an int field, is this possible or do I have to use a varchar or equivilent?

thanks

 

[JohnDTampaBay]

INT datatype will not store the leading zeros. You will have to use a CHAR or VARCHAR datatype.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.