Skip to Content
0

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

Dec 14, 2016 at 06:32 AM

98

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raghu Govindarajan Dec 14, 2016 at 03:47 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded