topic Re: Restrict selection using wildcards in Application Development and Automation Discussions

Restrict selection using wildcards

prince_isaac — Wed, 11 Mar 2009 13:33:58 GMT

hie guys

I have a select statement where i need to restrict the selected items where values in a field are ZP%


  SELECT * FROM marc INTO xmarc WHERE matnr IN material
                                 and werks ne 'ZP%'.
    IF sy-subrc = 0.
      APPEND xmarc.
    ENDIF.
  ENDSELECT.

the above code is not working for me. Could anybody advise me??

regards

Prince Isaac

Re: Restrict selection using wildcards

RichHeilman — Wed, 11 Mar 2009 13:36:15 GMT

and werks NOT LIKE 'ZP%'.

Regards,

Rich Heilman

Re: Restrict selection using wildcards

Former Member — Wed, 11 Mar 2009 13:36:21 GMT

use LIKE operand insted of ne

SELECT * FROM marc INTO xmarc WHERE matnr IN material

and NOT werks LIKE 'ZP%'.

reagrds,darek

Re: Restrict selection using wildcards

prince_isaac — Wed, 11 Mar 2009 14:38:59 GMT

Thanx Rich,

problem solved. Donno if u still need the points tho! lol.

regards

Prince Isaac