04-06-2016 5:40 AM
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.
04-06-2016 6:19 AM
That is possible. For instance if you are using an AMDP to push down the logic. In the AMDP you could use the UPPER function if you wanna compare against your upper case converted address. Or you could use a regular expression (with LIKE_REGEXPR) with case insensitive search option to compare against your not upper case converted address.
Regards,
Florian