Skip to Content
0
Former Member
Jun 11, 2009 at 07:30 AM

Fetch the EKPO-AFNAM data without case sensitive.

139 Views

Dear Friends,

I am fetching the data from EKPO table based on AFNAM ( Name of requisitioner/requester )field,

I do have 2 records in my EKPO table ( one is small case and second one Upper Case ) with name :

SRIDHAR

sridhar

I want to fetch the both records if I give the where class for EKPO-AFNAM = 'SRIDHAR'.

what I mean If I give Upper case or lower case I need to fetch both the records which are matching the where clause without case sensitive. Is it possible to fetch the data like this?

Thanks,

Sridhar