Case insensitive SELECT statment

[Former Member]

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

[schneidertho]

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

[amy_king]

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

[Former Member]

Thanks Amy...