Case-Sensitive

[Former Member]

Dear All,

In the input I am having Customer Name & Material Description. So, when I enter Customer Name or Material Description in the input then it should not be 'case sensitive' ie. it should display result even though the text is entered in Caps or in small alphabets.

Thanks in advamce.

Warm regards,

nishu

[athavanraja]

how thes texts are stored in database, mixed case? or upper case.

if upper case, convert your input to upper case and use it for select

[Former Member]

i think Selection is not case sensitive.

it will convert all to uppercase and check

[Former Member]

TRY TO USE

TRANSLATE c TO UPPER CASE.

REGARDS

SHIBA DUTTA

[Former Member]

Hi Nishu ,

It would be difficult , because it is based on how data is stored in the data base , now consider the scenario of the system i am using , we can material description as 'test' or 'TEST' , 'Test' .

If in your system there are only stored in either caps or small the you can perform the select twice .

But i myself dont find it to be such a good solution , but you can give it a try

There is one more solution specific to material description ,and that is in the table MAKT there is a field MAKTG , which stored the description in uppercase , so for this you can first convert the description to uppercase and then perform select on this field

Regards

Arun

[Former Member]

Hi ,

Normally selection screen elements take the input in caps .To make it to accept lower case letters we use

SELECT-OPTIONS <seltab> FOR <f> ... LOWER CASE

Regards ,

Senthil

Message was edited by: Senthil

senthil kumar

[Former Member]

Hello,

Use Translate var to UPper case.

or Translate var to lower case.

If useful reward.

Vasanth

[Former Member]

Hi,

Use <b>translate</b> statement to convert <b>Upper case</b> or <b>Lower case</b>

Regards,

Balavardhan.K

[Former Member]

Hi,

First select the data with Upper case if it is not satisfied try with Lower case.

Regards,

Balavardhan.K

[Former Member]

Hi All,

In the database text is stored in mixed formats ie. in uppercase, in lower case & some with both upper & lower case.

Warm regards,

Nishu

[athavanraja]

if the data is stored in mixed case in the database, the only option out is to read all the texts into a internal table convert them all the upper case, convert the user entered value into upper case and then do the search.

unfortunately this is the only way out.

Regards

Raja

[Former Member]

ok try like this

first translate the text in lower case to a variable1.

then translate the text in uppercase to variable2.

now take the value in your select-option-low and high and option BT sign I

append that in your select option.

now pass that to select statement.

I am not sure whether it will work or not..

regards

shiba dutta

[athavanraja]

nishu,

dont get confused.

whatever you enter in the selection screen will get converted to uppercase, if the addition lower case is not added to the parameter declaration.

in your case as you want the user to have the ability to enter mixed case words declare a parameter with the addition lower case.

and again i reiterate the only option left is to get all the texts convert them to upper case, convert the entered text to upper case and do a search,.

if you follow the method shiba suggested, it will not work in the following case.

for example.

data stored in the database is = myName

user enters = Myname

if you convert this to upper case = MYNAME

and use the user entered mixed case = Myname

your selecte wont find myName at all.

Regards

Raja

[Former Member]

what ever u enter in selection screen internally it takes as UPPER CASE and then fetches data relevant to it.

[Former Member]

Hi,

Can u give me what tables ur using.

Regards,

Balavardhan

[Former Member]

Hi All,

Thanks for ur valuable replies.

For Material Description now I have used the table MAKT-MAKTG where all descriptions are in Caps.

Is there any table where Customer Number is stored in Caps??

Warm Regards,

Nishu

[Former Member]

Hi ,

Do you want customer number or customer name .

If it is customer number , then i feel it is always stored in CAPS, so you do not need to bother about it.

Please check it and revert back in case of any queries.

Regards

Arun

[Former Member]

Customer Name is alsoc there in table KNA1 in Upper Case

[Former Member]

Hi,

Yes the customer name will not always be in KNA1 table in upper case , it can be in mixed format also.

Regards

Arun