Select query issue

[Former Member]

Hi,

i am having some trouble with select query.

lets say for example i have to select some customers for a given country, and the customer is entered using SELECT-OPTIONS . i have written this query -

SELECT *

FROM zmmknits

INTO TABLE it_final

WHERE vendor_name IN vndrname

AND country_v IN cntry

AND ( approved_cust1 IN cust OR

approved_cust2 IN cust OR

approved_cust3 IN cust OR

approved_cust4 IN cust OR

approved_cust5 IN cust OR

approved_cust6 IN cust OR

approved_cust7 IN cust OR

approved_cust8 IN cust OR

approved_cust9 IN cust OR

approved_cust10 IN cust ).

the problem i am facing is that say for example the customer entered is GEORGE and for the given country the customer is George Patro or George Wells, so according to my query its not pulling up these records which it should pull for my report.

kindly help

[Former Member]

<<Copy and paste from SAP Help deleted and awarded points removed>>

Edited by: Matt on Jan 29, 2009 9:27 AM

[Former Member]

This message was moderated.

[Former Member]

thank you very much for your reply... however we should note that LIKE or NOT LIKE works with parameters... and my data is entered through SELECT-OPTIONS

[Former Member]

SELECT-OPTIONs offer you to enter pattern like

*GEORGE*

on the screen field, and they work like LIKE clause with %GEORGE%

[Former Member]

thanks again to you... but can you just elaborate your answer a little bit as to how can i make SELECT-OPTIONS enter the data as GEORGE