Hi
I have a conversion job, job is working fine. But one of the column data is not matching when compare to production.
column data type is Char ( 9 )
In my production table the data is like this
000000001
000006535
000000023
009864321
After i ran job the data is loading in this format
1
6535
23
9864321
I need to add 0's ln left side.
Will it works
Str("0",9-Len(Lnk_In.V_NUM)) : Lnk_In.V_NUM
Any one can help me to resolve... ASAP please.
Left Padding
Moderators: chulett, rschirm, roy
Or
Code: Select all
Right('000000000' : Trim(Lnk_In.V_NUM), 9)
You are the creator of your destiny - Swami Vivekananda