Moderator message: please do not post the same question more than once
I need to select the data without considering any case sensitives.
Eg: If i enter ***JoHn****, then system need to select all currencies or amount depending on the this name.
Please assist, many thanks.
Edited by: Matt on Nov 20, 2008 1:16 PM
use cp or like in the select query
and more over any thing given in single quotes must be in upper case to my knowledge in ABAP.
any how try this
select * from dbtab where name like '%JoHn%'.
if doesnt work translate it to upper case.
hope this this would solve.
In database the data will be stored either in case sensitve or in Upper case...
You need to check whether the table has field for search and the values are stored in upper case...so you need to use these fields to fetch the data ...
In the select you can use Like option in where condition.