Question to convert the field type in Data Management Studio 2.4

[Shah]

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

[skillman]

This was answered here:

but to save you a click here is the solution:

/* Pre-processing Expression*/

string desired_output

hidden integer i

desired_output = ''

i = 0

/*Expression*/

if len(`COCD`) < 4

  begin

  desired_output = `COCD`

  while i <  (4 - len(`COCD`))

  begin

  desired_output = '0' & desired_output

  i = i + 1

  end

  end

else

  desired_output = `COCD`

  i = 0