Skip to Content
0
Former Member
Apr 06, 2016 at 04:40 AM

Code push down string comparison

42 Views

My requirement:

I have a Z config table which stores email addresses along with other stuff. I am writing a new method which queries that table to see if it contains a specific email address.

Problem:

If the email address I am querying contains upper case characters, I get wrong results.

Current process:

I select all the email addresses into an internal table, loop through and convert both to upper case and compare.

Question:

Is there a way to do code push down (ie) getting HANA to do all the hard work? I want to write something like SELECT SINGLE @ABAP_TRUE FROM.... I don't want to read all the email addresses and transfer them to application server. All I need is a YES or NO.