Skip to Content
0
Former Member
Mar 24, 2009 at 09:12 AM

how to work with case sensitive select quiry

26 Views

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