How to make my program case - in sensitive?

[Former Member]

Hi,

Iam writing a SELECT query in report for retrieving the address number by giving address details like street, city and post code.But my program is case sensitive such that if the user inputs either in Upper Case or Lower Case, it will not work.

For eg: suppose the city is Cape Town. If the user inputs like CAPE TOWN or cape town ( via Selection Screen ), then it won't work.

How can i make my program case- in sensitive?? please suggest..

[Former Member]

Hi,

Iam writing a SELECT query in report for retrieving the address number by giving address details like street, city and post code.But my program is case sensitive such that if the user inputs either in Upper Case or Lower Case, it will not work.

For eg: suppose the city is Cape Town. If the user inputs like CAPE TOWN or cape town ( via Selection Screen ), then it won't work.

How can i make my program case- in sensitive?? please suggest..

[Former Member]

Hello,

You can translate either to upper case or lower case depending upon ur requirement.

1. TRANSLATE c TO UPPER CASE. 

2. TRANSLATE c TO LOWER CASE. 

Hope this will solve ur issue.

Cheers,

Vasanth

[Former Member]

Hi Vasanth,

Thanks for your reply.

I already tried that one. But in Select query it is not matching with the street from the table, hence no records are fetched.

Please help me out.

[Former Member]

hi

good

i dont think there is any procedure in SAP to mare the report case sensitive.

thanks

mrutyuyn^

[Former Member]

This is possible. I have done something similar to it in my search programs.

For this we need to make a subroutine. In this subroutine we first need to convert the case into upper case using

TRANSLATE string TO UPPER CASE.

then prefix and postfix this string with &,

_and if this does not work then we have to break the srting entered by the user on basis of spaces and prefix and postfix it with &. _

Now pass this string to the query and it will definitely get the result.