Skip to Content
0
Former Member
Apr 30, 2009 at 01:43 PM

Issue with upper/ lower case in HR report...

57 Views

Hello,

I am working on a HR report. Based on last name on selection screen, I am fetching some data

from intotables.

The problem is, for example in case of last name, the system expects the user to type the

last name in exact case as its stored in database table.

So for example, if last name is "Anja" in database table, then if user types "ANJA" or "anja" or aNja, the

select query does not fetch the data.

How can I modify the query so that, even if user types last name in any case, it should still fetch the

record.

SELECT aPERNR bNACHN b~VORNA

INTO TABLE itab_data

from PA0001 as a

inner join PA0002 as b

on apernr = bpernr

where a~PERNR in S_PERNR

and a~BUKRS in S_BUKRS

and a~KOSTL in S_KOSTL

and a~PERSG in S_EMPGP

and a~PERSK in S_SUBGP

and b~NACHN in S_LAST.

Please help.

Regards,

Jainam.