selecting the data without considering any case sensitives

[Former Member]

Moderator message: please do not post the same question more than once

Hi,

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.

Sameer.

Edited by: Matt on Nov 20, 2008 1:16 PM

[former_member1245113]

Hi,

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.

regards

Ramchander Rao.K

[Former Member]

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

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

[matt]

Please do not post the same question more than once