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: 

Name case sensitive

Former Member
0 Kudos

Hi frnds

When i am trying to pull the customers based on the customer names. The name field in kna1 in the database it is pulling based on the case sensitive. Why is it happening? Is there any way we change any settings?.

Thanks

Satya

3 REPLIES 3

Former Member
0 Kudos

Hi,

Yes..It is case sensitive...Check the domain...The lower case flag is on for KNA1-NAME1...

If the flag is on..Then it will store all the records in the case given..

Otherwise..It will store in capital letters..

So in your case..I am sure there is no settings..

In your where clause...Give in both the cases..

Thanks,

Naren

0 Kudos

But i am not searching in the program.

I opened VD03 and then F4 and searched by name. When i do this i am getting only case sensitive names, like for example

if i type randy i am getting only names that are in small letters of that name.

if i type RANDY i am getting only names that are in capital letters of that name.

What can i do to avoid this. I need to get all names it should not check case.

Is there any way i can do that?.

Thanks

Satya

Former Member
0 Kudos

Hi,

I am not sure if there is a way around for this..

Thanks,

Naren