case sensetive

[Former Member]

Hi All,

I am retrieving the data from database tables (data element with type CHAR and property in Domain is Lower case). There some records in uppercase, some records in lower case and some records in both upper and lower case (test-DEMO-test). When i give value in selection screen in lower case it is retrieving for only upper case, the other cases are ignoring.

Is there any method to populate the selection screen values without changing the case.

Thanks in advance

Rajeev.

[Former Member]

use the keyword "lowercase". then it works

go for parameter otherwise

regards,

Sandeep Josyula

*Mark helpful answers

[Former Member]

Hi Sandeep,

The requirement was to retrieve the data, which is similar to “demo-IND-contract” and am using the select-options.

If I use lower or upper case, the select statement is not retrieving the above one

If I give demo it works

If I give IND it works

If I give demo-IND its not working.

Kindly suggest.

Thanks,

Rajeev.

[jayanthi_jayaraman]

Hi,

parameters p(10) lower case.

write p.

Input:demoIND

Output:demoIND

lower case addition to parameters will take care of the data as it is inputted[case sensitive].

[Former Member]

Hi Rajeev,

While declaring selection screen, use Case sensitive statement for that field. It solves ur problem.

regards,

Chandra

[Former Member]

Hi Chandra,

Some of the records are in upper case ...

[Former Member]

Hi Muthu,

In selection screen

give the lower-case addition.

parameters: p_matnr(10) lower-case.

Regards,

ravi

[Former Member]

There are different techniques depending on the table. So could you tell us which table?

Rob