topic Re: Selecting text field from table ignoring capitalization in Application Development and Automation Discussions

Selecting text field from table ignoring capitalization

Former Member — Thu, 28 Jan 2010 04:43:15 GMT

Hi,

i'm doing a read on a table using select.....where text in s_text . if i want to ignore the capitalization; how to perform the read.

for eg : if the text is saved as 'Name' and in my select criteria if i specify the selection text as 'name' it should pick up even if 'N' is not in CAPS in DB.

Thanks,

GV.

Re: Selecting text field from table ignoring capitalization

Former Member — Thu, 28 Jan 2010 05:01:09 GMT

Hi,

The Function Module, STRING_UPPER_LOWER_CASE will convert your string to lower case except the first letter

So if user input as name, after passing it to FM you will get the value as 'Name' and then you can able to check your condition

May this will help you

Rani

Re: Selecting text field from table ignoring capitalization

Former Member — Thu, 28 Jan 2010 05:26:40 GMT

hi,

Use TRANSLATE s_STEXT TO UPPER CASE and then use it in selection screen .

Press F1 on Translate and read help in it

hope it helps

thanks.

Re: Selecting text field from table ignoring capitalization

SuhaSaha — Thu, 28 Jan 2010 05:27:23 GMT

Hello GV,

This is a FAQ. AFAIK there are no techniques in Open SQL which will enable you to select case sensitive fields . If you have to use Open SQL then you have to select data in some internal table & then filter the data based on the input text field.

BR,

Suhas

PS: You can try using Native SQL techniques though.

Re: Selecting text field from table ignoring capitalization

Former Member — Thu, 28 Jan 2010 05:37:22 GMT

Hi,

In the Select Query All text are case Sensitive .

So all text data has to be converted to UPPercase letter during Select statement either by using Stanadard SAP FM or using Translate Keyword.

It will work.

Regards

Arbind

Re: Selecting text field from table ignoring capitalization

kesavadas_thekkillath — Thu, 28 Jan 2010 15:55:42 GMT

This question is asked many times in this forum.

if its a ztable you have created then you can play with case sensitive option in domain.

or else...try to find whether there is any other fields which holds the value in full caps( ex:makt-maktx,makt-maktg), so

that you can convert the whole to caps and then select.