Skip to Content
0
Nov 30, 2005 at 08:09 AM

SELECT WHERE a IN range (IGNORING CASE)?

140 Views

I do a select on a database table using a range table.

ls_search_criterium-sign   = 'I'.
ls_search_criterium-option = 'CP'
ls_search_criterium-low    = '*abc*'.
"...
SELECT * FROM table INTO TABLE lt_table
         WHERE field IN ltr_search_criteria.

This code finds all entries containing the text "abc".

Now, I would like to also find "ABC" or "Abc".

Is there a way to this without several select statements?