Leading zero, But 'n' Number of times (No Lpad)

[Former Member]

Hi,

Lpad( 'ABC',6,'0') will give me the output

'000ABC'

What if '6' is dynamic (n number of times)? How to do it? Lpad can take only constant value.

Please help!!

[former_member208402]

Hi Mohan,

in what cases that 6 will be changed..? so that we can try this using a variable in the place of 6 i guess.