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.
cancel
Showing results for 
Search instead for 
Did you mean: 

like case sensitive

Private_Member_101989
Contributor
0 Kudos
106

Hello,

How can make a selection using like and making it case not sensitive ?

Example:

Select * from X Where Y like '%aaaa%'.

The above clause will only work if aaaa are in lower case, how can i make it case not sensitive ? If there is any.

Regards,

Jorge Diogo

1 ACCEPTED SOLUTION

Former Member
0 Kudos
76

it is not possible....so try like this...


Select * from X Where Y like '%aaaa%' or '%AAAA%'.

5 REPLIES 5

Former Member
0 Kudos
77

it is not possible....so try like this...


Select * from X Where Y like '%aaaa%' or '%AAAA%'.

Former Member
0 Kudos
76

I think ,there is no such command in ABAP.

Jus see whether this may help you.

TRANSLATE string TO UPPER CASE

Former Member
0 Kudos
76

Did you try with CS statement ??

0 Kudos
76

Hello,

CS statement does not work in selections, translate does not apply in my case and using all combinations is what i was using.

But thank you anyway, i guess is not possible in abap.

Regards,

Jorge Diogo

Former Member
0 Kudos
76

The problem with the CS aproach is that it's not a valid operator for SELECT.

Perhaps you could create an internal table with the table entries selecting them for any other criteria you had and then filter that internal table with the CS operator. I don't know the ammount of entries you have on that table, so I don't know if this is a valid aproach for you.