I have tried the above tostring function and it is working fine. Thank you so much for the above solution and also regret for the late reply.
I have one more question to ask, I have the field COCD with the len 1, 2, 3, and 4 digits. The COCD column must consist of 4 len number as per our requirement so i have to prefix each company code with '0' to make it 4 digit. Is there any solution or functionality i can use to change the len to 4 digits?
I have used below the expression but not yielding result:
if len(COCD) == 1 then cocd_text = left(000,COCD)
COCD | Required Output |
1 | 0001 |
2 | 0002 |
11 | 0011 |
22 | 0022 |
333 | 0333 |
4444 | 4444 |
Regards,
Shaheen