Hi Friends!
I have an oracle database and i want to do string comparision.
But i have and problem.
I can use these sql in oracle gui
<b>select UPPER(BTITLE) from sapsr3db.bilim_blog
select BTITLE from sapsr3db.bilim_blog where {fn LCASE(bilim_blog.BTITLE)}='test'</b>
But i cannot use in J2ee sap portal application. It gives these error sequently
<b>Upper Function are not allowed here</b>
<b>SQL syntax error: an illegal character "{" has been found in the statement text </b>
Also someone asked same question before and didnt get answer.
<u>case-insesitive-string-comparison-in-open-sql</u>
Best Regards
Eray