Selecting text field from table ignoring capitalization

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[SuhaSaha]

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.

[Former Member]

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

[kesavadas_thekkillath]

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.