Padding zero's before the value based on the data
Posted: Tue Feb 22, 2011 9:53 am
HI
I have one requirement i am tring to load data into the target like:
my input data size is numeric(10), if i get the data like 25685, i need to load into the taget like 0000025685
if data is coming 5 digit , remaining preceeding zero's should come, if 2 digit data is coming 8 digit zero's should come.
please help me to know the resolution.
thanks in advance
suma
I have one requirement i am tring to load data into the target like:
my input data size is numeric(10), if i get the data like 25685, i need to load into the taget like 0000025685
if data is coming 5 digit , remaining preceeding zero's should come, if 2 digit data is coming 8 digit zero's should come.
please help me to know the resolution.
thanks in advance
suma