How to avoid case sensitivity in select statement while matching with the range table

[Former Member]

Hi Experts,

I am accepting the first name and last name  of client from the ui . now these datas are coming in range table.

My requirement is i need to match these names with out case sensitiveness.

Eg: input Vinod then it should match below all

VINOD

vInod

VInoD

[Former Member]

Which table you are querying it into ? Check if the table has a field which holds the value in ALL CAPS. In this case, translate everything to caps and query it.

As Raymond said, Search for the available information.

[former_member585060]

Hi,

    Move the data to a new field, then translate them to UPPER CASE or LOWER CASE and then use that variable for comparision.

Ex:-

DATA : lv_name TYPE c LENGTH 15,

             lv_field   TYPE c LENGTH 5.

  lv_field = 'Vinod'.

  TRANSLATE lv_field TO UPPER CASE.

LOOP AT r_name1.

  lv_name = s_name1-low.

  TRANSLATE lv_name TO UPPER CASE.

  IF lv_name1 LIKE lv_field.

    Your logic

  ENDIF.

  CLEAR : lv_name.

ENDLOOP.

Thanks & Regards

Baa Krishna

[Former Member]

Hi,

one possible solution is Select everything by other selection conditions except name. Loop at internal table and convert name to uppercase and check this name exists in your range. Now you can delete record if it is not found in range.

thanks.

[RaymondGiuseppi]

This is a FAQ, use search tool to find information at scn like documebnt Case Insensitive Search Helps Using Native SQL or discussion Case insensitive search in select statemen

(Read the Rules of Engagement)

Regards,

Raymond

[kesavadas_thekkillath]

Which table you are querying it into ? Check if the table has a field which holds the value in ALL CAPS. In this case, translate everything to caps and query it.

As Raymond said, Search for the available information.

[Former Member]

Hi Vishal,

            you can use operators for comparing strings like CS (Contain String).

Refer to the below link for comparing strings with case insensitiveness.

http://help.sap.com/saphelp_bw/helpdata/en/fc/eb3516358411d1829f0000e829fbfe/content.htm

Regards

Sindhuja