topic Re: like case sensitive in Application Development and Automation Discussions

like case sensitive

Private_Member_101989 — Thu, 08 Jan 2009 11:10:47 GMT

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

Re: like case sensitive

Former Member — Thu, 08 Jan 2009 11:19:59 GMT

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


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

Re: like case sensitive

Former Member — Thu, 08 Jan 2009 11:22:38 GMT

I think ,there is no such command in ABAP.

Jus see whether this may help you.

TRANSLATE string TO UPPER CASE

Re: like case sensitive

Former Member — Thu, 08 Jan 2009 11:25:45 GMT

Did you try with CS statement ??

Re: like case sensitive

Private_Member_101989 — Thu, 08 Jan 2009 11:43:02 GMT

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

Re: like case sensitive

Former Member — Thu, 08 Jan 2009 11:46:25 GMT

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.