like case sensitive

[Private_Member_101989]

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

[Former Member]

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

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

[Former Member]

I think ,there is no such command in ABAP.

Jus see whether this may help you.

TRANSLATE string TO UPPER CASE

[Former Member]

Did you try with CS statement ??

[Private_Member_101989]

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]

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.