Loop with where statement containing *

[Former Member]

Hello experts,

I have this statement:

LOOP AT i_sorg WHERE q = quality

AND s = size

AND v = variant.

....

....

APPEND i_result.

ENDLOOP.

However for the size I need to give the user to enter wild cards "*"as well as ?. If the size contains "" the loop doesn't find the record. If I translate the "" in to "%" it doesn't run either so what should I do that the WHERE statement find the record.

Thanks

[ThomasZloch]

use the LIKE operator instead of "=" combined with the wild cards "%" and "_".

Thomas

Edit: operator CP with "*" and "+" should work as well.

Edited by: Thomas Zloch on Aug 13, 2008 12:51 PM

[peter_ruiz2]

Hi,

using CP instead of the = sign.

regards,

Peter

[Former Member]

Hi,

Inside loop put check for the charecter '*' using FIND and use sy-subrc for your action.

Sudheer. A

[Former Member]

Hi,

Inside loop check fop the charecter '*' using FIND and then if sy-subrc = 0 then do your action.

Sudheer. A

[Former Member]

use LIKE instead of =.

[former_member787646]

Hi,

Try this...

Data: vSize(10).

IF size = ''.

vSize = '*'.

ENDIF.

LOOP AT i_sorg WHERE q = quality AND s CP vSize AND v = variant.

....

....

APPEND i_result.

ENDLOOP.

Hope it helps.

Murthy