Is it that SQL will not save any leading zeros of a field data type int or numeric? If it is so then how can one make the leading zeros stored if they really want it?
Printable View
Is it that SQL will not save any leading zeros of a field data type int or numeric? If it is so then how can one make the leading zeros stored if they really want it?
store them as character data...
Thank you. I tried and it worked. Good tip that provided me the insight about the data types in SQL.