Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Add Leading zeros in record

Hi,

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.

Adhiraj

0 Community Answers

Post Your Community Answer

To add an answer please login