OPEN SQL WHERE CLAUSE

[Former Member]

Hello everybody,

I have to do a select to the EDIDC table as follows:

CONCATENATE '%' wa_idocs-idocfuente '%' INTO idockey.

SELECT SINGLE docnum status

INTO (wa_idocs-idocdestino,wa_idocs-statusdest)

FROM edidc

WHERE arckey LIKE idockey.

now this is very poor performance query, now the problem is that the arckey field is a string field, now does anyone nows a more efficient way to do this, we are evaluating an Index but that would mean more space, thanks for any suggestions.

Regards,

Julio

[former_member156446]

use selopt std. structure and build a range table and use that....

selopt-sign = 'E'.
selopt-option = 'CP'.
concatenate '*' wa_itab-value '*' into selopt-low.

append selopt.

select......where value in selopt.

[Former Member]

thanks for you answer