Comparison operator in select query

Hi,

I am retrieving USOBJ from AEOI table.

* CONCATENATE '%' '000000010010553' '%' INTO va_usobj.

* r-sign = 'I'.

* r-option = 'CP'.

* r-low = '000000000010010553*'.

* APPEND r.

SELECT * FROM aeoi

INTO TABLE gt_aeoi

WHERE usobj LIKE va_usobj.

IF sy-subrc EQ 0.

1. ENDIF.

I have tried out with CP, by passing range , LIKE . None is working.

Since large no of entries are existing in AEOI.

we cant select all the entries from table and again looping the table

will create performance issue.

Please let me know any other possibility if exist.

Thanks.

Best Regards,

Mallesh