Restrict selection using wildcards

[prince_isaac]

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

[RichHeilman]

and werks NOT LIKE 'ZP%'.

Regards,

Rich Heilman

[Former Member]

hi

use LIKE operand insted of ne

SELECT * FROM marc INTO xmarc WHERE matnr IN material

and NOT werks LIKE 'ZP%'.

reagrds,darek

[prince_isaac]

Thanx Rich,

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

regards

Prince Isaac