Dear All
I have a table with field "Rt" which is a text field.This field has above 50000 data values of 3 Digit like 152, 56, 2, 010, etc.
What I need for exporting purpose in COBOL is that this data should become like 152, 056, 002, 010, etc. means if two digits data then replace one 0, if one digit then replace two 0.
I used following expression in an update query.
If len(int[Rt])<0 then move 0
but its not working. Am I going wrong if yes please help me as early as possible.
Thanks.
Wasim