Add Leading zeros in record
I have a transformation which loads data one to one from a view to a target.
Now I have a column varchar(5). I want add leading zeros whenever record length is less then length 5.
For example: if my record is '123,' I want to load it as '00123' or if my record is '8765', I want to load it as '08765'.
Thanks in advance.