Variable as a length in RIGHT SQL function?

Question

I want to use this Open SQL code in my ABAP code :

  SELECT RIGHT( NODENAME, LENGTH( NODENAME ) - 8 )
      FROM  RSMHIERNODE
      WHERE HIEID = 'HRJ'
      INTO TABLE @lt_commentdata.

but when I try to activate the method I have this error :

In the function RIGHT , the parameter number 2 must be an abap variable. this is not the case for the expression that starts with 'LENGTH'.

Have any idea how can I solve this ?

Jonas Wilms · Accepted Answer · 2021-09-20 20:16:06Z

1

You cannot use operator for length of RIGHT function. You need to give exact value. You can use SUBSTRING function with huge length.
Example:

SUBSTRING( NODENAME, 8, 999 )

edited Sep 20, 2021 at 20:16

Jonas Wilms

139k20 gold badges164 silver badges164 bronze badges

answered Sep 20, 2021 at 15:57

mkysoft

5,7881 gold badge26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sandra Rossi Over a year ago

SUBSTRING(NODENAME, 8, 999) produces a syntax error because of missing spaces around parentheses. Shouldn't it be 9 instead of 8? Note that the parameter 2 of RIGHT can be a SQL expression from ABAP 7.55.

emilie Over a year ago

thank you mkysoft , it solves the problem . Just as @SandraRossi said there is a missing spaces around parentheses .

Collectives™ on Stack Overflow

Variable as a length in RIGHT SQL function?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related