How to ignore small/capital characters in select?

[Former Member]

Hi everyone,

How to ignore the small/capital characters in select order? As the code below, how to ignore the capital/small letters in stext?

SELECT abc FROM p1000 INTO table-abc WHERE stext LIKE stext.

Thanks!

[Former Member]

Hi,

First covert all texts to lower or upper case using

TRANSLATE text TO UPPER CASE.

or

TRANSLATE text TO LOWER CASE.

Regards

jana

[Former Member]

Thanks, but I can't modify the standard table (p1000-stext), also it's no use to convert table-stext cause in p1000-stext there are both small letters and capital one. So is there any other method?

Thanks.

[Former Member]

Not sure whether there is a case sensitive comparison operator within a SELECT statement in ABAP

Alternatively, maybe try selecting all data, then looping through it to check for your case-sensitive search string using something like IF CP 'whaTevEr tExt' as that operator is not case-sensitive.

[Former Member]

HI,

Use TRANSLATE text TO UPPER/LOWER CASE.

Rajendra

[Former Member]

Hi,

Get into the SE38 --> program name -- >change-->

Utilities> settings-> Abap Editor ---> Pretty printer

---> Select Upper case (Radio Button) press Enter

Thank U

Rajesh Balakrishnan