04-23-2007 9:11 PM
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
04-23-2007 9:17 PM
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
04-23-2007 10:17 PM
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
04-23-2007 10:20 PM