hi
i have developped a ztable and filled the table programatically. like bellow
stdid stdname(non key)
001 ramu
002 somu
003 RAJU
when i write select quiry on this table like
select *
from zstudent
into table itab
where stdname = 'ramu'.
i found no records in itab.
i also tried with
select *
from zstudent
into table itab
where stdname = 'RAMU'.(by giving where filed in capital)
but i found no records in itab.
when i tryied with
select *
from zstudent
into table itab
where stdname = 'RAJU'.
i found the record in itab.
as per my analysis if database is updated with capital letters,then only select is working
but how to make the fist two select querys to be worked out.without modifying database entries