Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to make my program case - in sensitive?

Former Member
0 Kudos

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..

4 REPLIES 4

Former Member
0 Kudos

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

0 Kudos

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
0 Kudos

hi

good

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

thanks

mrutyuyn^

Former Member
0 Kudos

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.