topic How to avoid case sensitivity in select statement while matching with the range table in Application Development and Automation Discussions

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

Former Member — Fri, 30 Nov 2012 07:27:19 GMT

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

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

former_member585060 — Fri, 30 Nov 2012 07:40:51 GMT

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

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

Former Member — Fri, 30 Nov 2012 07:41:22 GMT

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.

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

RaymondGiuseppi — Fri, 30 Nov 2012 07:48:50 GMT

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

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

kesavadas_thekkillath — Fri, 30 Nov 2012 08:16:28 GMT

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.

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

Former Member — Fri, 30 Nov 2012 09:21:24 GMT

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