Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Leading zeros
Message
From
11/09/2000 13:57:28
 
 
To
11/09/2000 13:51:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00414999
Message ID:
00415007
Views:
19
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform