Upper Case and Lower Case
Facing one problem, while selecting data from the table KNA1 in where clause .
Lets take example :
If data in the table in name field is shilpi agarwal
and i am selecting Shilpi Agarwal in which S,A in caps then it is not selecting .
If data in the table in name field is Shilpi Agarwal
and i am selecting shilpi Agarwal in which S,A in caps then also it is not selecting .
means if the case in records and section creteria same then only it select .
Please provde me feasible soln