I'm saving several eg. 000001 inside a SQL TEXT area which in turn causes the key zeros to become lost.
I want the written text type area because the data could have letters and/or amounts.
Any suggestions the way i could preserve the key zeros while still storing the information inside a TEXT type area?
0000001 isn't a number. It's a string. Are you currently attempting to store several one in a text area, or are you currently attempting to keep string
'0000001' inside a text area? I suppose however , you do th former.
If you think maybe you aren't doing that, show us your code.