Posted by Nitin Pai
November 20th, 2008


This is related to data conversion.
I want to convert a string to a number. The string contains zero at the first position. while conversion, other values get converted except the zero. During print, we can print the zero using edit mask. But I want the number to be stroed with Zero at the first position.
Is there any ways to achieve it? Please explain.


Thanks for posting your question!
If you need to store ZERO at the first position then you will need to use character data type. Or use edit mask (as you have approached) to print zero as the first field.

You cannot store a value with leading zero followed by numeric data in a field with datatype number.

Nitin Pai

Comments (0)