topic Re: How to make my program case - in sensitive? in Application Development and Automation Discussions

How to make my program case - in sensitive?

Former Member — Mon, 11 Feb 2008 10:18:23 GMT

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

Re: How to make my program case - in sensitive?

Former Member — Mon, 11 Feb 2008 10:21:46 GMT

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

Re: How to make my program case - in sensitive?

Former Member — Mon, 11 Feb 2008 10:36:13 GMT

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.

Re: How to make my program case - in sensitive?

Former Member — Mon, 11 Feb 2008 10:49:44 GMT

good

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

thanks

mrutyuyn^

Re: How to make my program case - in sensitive?

Former Member — Tue, 12 Feb 2008 10:56:01 GMT

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.