Dear all,
In my table in MSSQL 2005, there is a field int type. Now the requirement is that there could be a possibility of zero's at the begining of the data eg 001234. but the database trims the '0' which are the begining and stores it as 1234. what is the best alternative apart from changing it to varchar

Thanks