Skip to Content

how to include a word in between a string using lpad function but with out using concat function

Hello Experts

I want to include a word in between a string using lpad function but with out using concat function

eg 'hello world' is the string I want add my in the place of space using lpad function , so my out put should look like something like this 'hellomyworld'

can anyone please guide me.

Thanks

Naresh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 14, 2016 at 03:47 PM

    From SAP help - "LPAD(x,a,y,n) is a string function that inserts the character string y at the start of the character string x as often as specified by the parameter a. Leading and subsequent blanks in the character string x are truncated."

    By definition, you cannot change something in the middle of your string using LPAD. Why don't you consider using REPLACE instead.

    Add comment
    10|10000 characters needed characters exceeded