topic Re: Case insensitive SELECT statment in Application Development and Automation Discussions

Case insensitive SELECT statment

Former Member — Wed, 05 Dec 2012 19:37:41 GMT

Hi,

I want to fetch data from KNA1 based on a few fields in my search screen,which includes namecity,search term etc.But my requirement is,if I give the city name in full Upper case,or full Lower case,or Camel Case, I want all the records which is similar,including the same string n upper case,lower case and came case.

How can I achieve this through an Open SQL statment?

Moderator Message: Please search in SCN before posting. Similar questions were asked and answered several times before.

Removing the question status.

Message was edited by: Kesavadas Thekkillath

Re: Case insensitive SELECT statment

schneidertho — Wed, 05 Dec 2012 20:14:35 GMT

Hi lavanya,

I am not sure, if I understand completely what you mean by 'similar'.

If you enter Mayer and you want to find MAYER, mayer, MAyer - then I don't think that you can express this with Open SQL. But I guess you can do it with native SQL.

Furthermore you could check if the fields you need are also stored in upper case in KNA1.

Customer master is not my home turf. But to me it seems that, for instance, NAME1 is also stored completely in upper case in MCOD1.

Best regards

Thorsten

Re: Case insensitive SELECT statment

amy_king — Wed, 05 Dec 2012 20:39:34 GMT

Hi Iavanya,

You can translate your search terms to upper-case and then in your SELECT, compare the fields to the corresponding MCOD* fields which are upper-case only.

Cheers,

Amy

Re: Case insensitive SELECT statment

Former Member — Thu, 06 Dec 2012 04:52:57 GMT

Thanks Amy...