topic Re: case insensitive search in select statement in Application Development and Automation Discussions

case insensitive search in select statement

Former Member — Mon, 21 Dec 2009 06:18:21 GMT

Hi Experts,

I have entries in table as mixed case. For example i am searching on an attribute called description in the table. I want the serch to be case insensitive for that attribute. Because in table it is i.e. JUMBO Pack and in the search attribute it is i.e. Jumbo Pack.

I do not want to translate both to the same case and search. Is there an option?

Best Regards!

Sandip

Re: case insensitive search in select statement

Former Member — Mon, 21 Dec 2009 06:26:21 GMT

Hello,

Check if the Lowecase checkbox is checked in the domain attributes of the particular field of the table. If its a Z table, and this checkbox is not set, you can check it and make the search case insensitive.

Vikranth

Re: case insensitive search in select statement

kesavadas_thekkillath — Mon, 21 Dec 2009 06:32:10 GMT

If its not a 'Z' table then there is no option.

But you can try some thing like

if aB is the input.

You can generate the cobinations and put into a range and then use in select

Its a hard logic to build .. BUt i see this as an option

Re: case insensitive search in select statement

Former Member — Mon, 21 Dec 2009 06:35:33 GMT

Hi Vikranth,

The checkbox is checked in the domain. That is why, "If this indicator is set, upper case and lower case are distinguished when you enter values with screen masks.

Otherwise all the letters entered will be converted to upper case when you enter values with a screen mask.

This mechanism is in effect for all the fields referring to this domain.".

This doesn't help my purpose. Thanks for the help.

Best Regards!

Sandip

Re: case insensitive search in select statement

Former Member — Mon, 21 Dec 2009 06:36:57 GMT

Hi KSD,

This seems to be a much tougher proposition than converting both strings to a common case and compare.

Thanks for the help.

Best Regards!

Sandip

Re: case insensitive search in select statement

former_member217544 — Mon, 21 Dec 2009 06:52:16 GMT

Hi Sandip,

One more alternative:

If ztext is ur original field which is saving the mixed text.

Append one extra field(ztext_upper) to the table.

Now if " Sap Sdn" is the text we are saving then

While saving the entires to the table,

1. asusual save the value(" Sap Sdn") to teh original field(ztext)

2. translate the value to upper case(SAP SDN) and save this entry to teh newly appended field(ztext_upper)

Now while doing search, translate to upper case and compare with the value in ztext_upper. If it satisfies then for display options select the original value from the field (ztext) which is corresponding to the satisfied ztext_upper field.

Regards,

Swarna Munukoti.

Re: case insensitive search in select statement

kesavadas_thekkillath — Mon, 21 Dec 2009 07:03:54 GMT

HI Sandeep,

Which table you are using ?

Re: case insensitive search in select statement

former_member156446 — Mon, 21 Dec 2009 07:15:32 GMT

Hi Sandip, I wrote a wiki for a similar scenario: [select the text from lower case data element|http://wiki.sdn.sap.com/wiki/x/6gGHBQ] hope that helps you.

Re: case insensitive search in select statement

Former Member — Wed, 23 Dec 2009 02:58:41 GMT

Hi Guys,

Thanks for your suggestions. But i do not find a direct alternative to translating and comparing. So i am closing the message. Atleast this post helped to know that there is no direct ABAP supported way to copare mixed strings. Eg: like ignore case parameters for string matching in many languages .

Thanks!

Sandip