String retrival

[Former Member]

Hi all,

How to retrieve string value which is given in a parameter as such. That is, if i give a string like 'Wett', it is being changed to 'WETT'. But i want it to be 'Wett' only. How to do that?

Regards,

Harish.

[Former Member]

in table declaration, there is a small checkbox, which allows small characters in table fields.

check it.

OMG lol not table declaration i´m a moron, rather go fpr the post below mine

Edited by: Florian Kemmer on Mar 3, 2008 3:58 PM

[Former Member]

hi ,

use this ,

parameters:p_like(10) type c lower case.

write:/ p_like .

[Former Member]

Hi Harish,

This can be done using domain defination. Just go to SE11 and domain of the data element you are using and check the check box which allows lower case.

Regards,

Atish

[Former Member]

This can be done using domain defination. Just go to SE11 and domain of the data element you are using and check the check box which allows lower case.

Man! You don't want to do that on a Standard Data Element, don't you?

It's better to use LOWER CASE extension...Or maybe...

TRANSLATE P_PARAM TO LOWERCASE.

Greetings,

Blag.

[Former Member]

Then declare the parameter LIKE the filed you are SELECTing.

Rob

[Former Member]

You can use native SQL so that the case doesn't matter either on the selection screen or the database.

Rob

[Former Member]

Hi,

I tried with the native SQL. But it didn't work. Actually my requirement is, i need to check the select option value with the table ( STD table) field. I need to retrieve the records whose name (field name is NAME1) equals to 'Wett'. In table, it is stored as 'Wett' only( First letter alone is in CAPS, others are in SMALL), But inside my coding, the select option value is changed WETT (All CAPS), so it doesnt retrieve the records whose name is 'Wett'. How to resolve this?.

Could anyone tell me clear idea..

Regards,

Harish.

Edited by: Harish Kumar on Mar 4, 2008 12:00 PM

[Former Member]

hi check this ,

parameters:p_test(10) type c lower case.

write:/ p_test.

parameters:p_test1(10) type c .

write:/ p_test1.

pass the name with the lower case then you got the result,

<REMOVED BY MODERATOR>

venkat.

Edited by: Alvaro Tejada Galindo on Mar 4, 2008 12:07 PM