>Is there any way to save the leading zeros in a table? I have a value of 00205003 but when I save it it cuts off to 205003 because it is an numeric value in the table. I want to keep the original value.
>
>TIA,
>Tyler
So this is a numeric field?
In that case, it won't keep the leading zeros. It would have to be a character field to do this.
Either that, or store the numeric as all decimals - so the value would be 0.00205003
Insanity: Doing the same thing over and over and expecting different results.