Skip to Content
avatar image
Former Member

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

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!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 27, 2017 at 08:10 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded