CODEWITHSUNDEEP
abapopensql
emilie
emilie

Reputation: 25

Variable as a length in RIGHT SQL function?

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 ?

Upvotes: 1

Views: 853

Answers (1)

mkysoft
mkysoft

Reputation: 5758

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 )

Upvotes: 1

Related Questions