Skip to Content
0
Former Member
Mar 22, 2010 at 03:48 PM

Help sql substring column

119 Views

Hi All,

I'm tying to execute this query

selecy matnr (sonum,1,10) as zsonum1 (sonum,11,16) as zsinum2 gesme

INTO CORRESPONDING FIELDS OF TABLE wt_stabr

from linv.

In other words I wish to split the sql field sonum (16) into two fields of my internal table (zsonum1 (10) and zsonum2 (6).

I can't execute the query because I have a sintax error about the comma.

Any help will be well appreciated.

Thanks in advance for your kind support.

Luigi