Skip to Content
0
Former Member
Mar 18, 2009 at 02:17 PM

Substring in Select

716 Views

Hallo

I have problem with following code. Can some body tell me how can I do it better.

SELECT pspnr FROM prps INTO TABLE lt_prps

WHERE fakkz = 'X'

AND pspnr+0(3) = 'C-55'.

I want to check for first four position of prps

Thank