Select statement....using wild character

[Former Member]

Hi All,

SELECT EKGRP EKNAM FROM T024 INTO TABLE IT_T024 WHERE EKGRP = S_EKGRP AND EKNAM NE 'NOT VALID%'.

My requirement is to eliminate the EKNAM (Purchasing Group Name) starting with NOT VALID string.

Any hint...

Thanks,

Kal Chand

[Former Member · Accepted solution]

Use NOT LIKE instead of NE

...EKNAM NOT LIKE 'NOT VALID%'.