add leading space and leading zeros

[ajithaselvan]

Hi,
I want all my output fields should be Right aligned.

Eg 1: If my input field: Col1, data type: Char(4), field value:+1
My output should be: +1 (2 leading spaces then field value)

Eg 2: If my input field: Col2, data type: integer(4), field value:10
My output should be:0010 (2 leading zeros then field value)


Kindly help me to resolve it.



Regards,

[Ravi.K]

Try the below drivations.

Col1--> Right(" ":Col1,4)
Col2--> Right("0000":Col2,4)

[ajithaselvan]

Thanks Ravi