Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Code push down string comparison

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.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question