Database Field Type

<i><b>Originally posted by : Gaurang (gvyas2000@hotmail.com)</b></i><br />I have a field called Site Code. The field is of type "small int". The field takes in int value from the user of size 4. So if the user enter "5555" it is saved in this column. But if the user enters "0001" then on "1" is saved and "0410" the database hold the value of "410". So basically it truncates out the preceding "0". This zeros are significant in the field value. How should I set the field so that the exact input from the user is saved to the database.<br />

<i><b>Originally posted by : Darren DiPasquale (aliasce@home.com)</b></i><br />SQL will not save leading 0's in any field that is numeric or int. If you must have a leading 0 use a varchar(5) field it will hold a leading 0. You can convert the varchar (in SQL and ASP) to an int in order to do any calculations. If you need the leading 0 for display purposes you can parse the varchar and depending on the number of characters it finds you can tell it to place the required number of leading 0's<br /><br />I hope this helps<br /><br /><br />D<br />------------<br />Gaurang at 3/22/2000 9:52:29 AM<br /><br />I have a field called Site Code. The field is of type "small int". The field takes in int value from the user of size 4. So if the user enter "5555" it is saved in this column. But if the user enters "0001" then on "1" is saved and "0410" the database hold the value of "410". So basically it truncates out the preceding "0". This zeros are significant in the field value. How should I set the field so that the exact input from the user is saved to the database.<br />