Ask the Experts – 47

Hi,

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
Radha.

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.

Thanks
Nitin Pai

All Rights Reserved © 2009 Hexaware Technologies.