Skip to Content
0
Former Member
Dec 27, 2007 at 11:28 AM

Not Like in Select Statement

4977 Views

Hi All,

My requirement is not to select the entries for the T024 table where the eknam is either starts with 'NOT VALID' or blank.

For that, I have written the select statement using NOT LIKE,

Will this negation in the select statement cause extra execution tiem?

If so, can you give some hint for alternative statement.

SELECT EKGRP EKNAM FROM T024 INTO TABLE IT_T024

IT_PURC WHERE EKGRP = S_EKGRP AND EKNAM NOT LIKE 'NOT VALID%' AND EKNAM NOT LIKE ' '.

Thanks,

Kal Chand