Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

selecting the data without considering any case sensitives

Former Member
0 Kudos

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


Active Contributor
0 Kudos


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.


Ramchander Rao.K

Former Member
0 Kudos

Hi ,

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 you need to use these fields to fetch the data ...

In the select you can use Like option in where condition.

Active Contributor
0 Kudos

Please do not post the same question more than once