Adding leading zeros to the field value

More
12 years 6 months ago #1978 by Melinda
Hi there,

Can someone tell me how to put leading 0 in front of field value?
I am new here and I don't know if there is a function for this or not. :unsure:

Thanks,
Melissa

Please Log in or Create an account to join the conversation.

More
12 years 6 months ago #1980 by admin
This can be easily achieved by using Left pad function.

See attached picture

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
12 years 6 months ago #1981 by Melissa
Thank you very much for the quick response
It is all working as expected.

Melissa

Please Log in or Create an account to join the conversation.