Skip to Content
0
Jul 20, 2007 at 09:05 AM

Upper and Lower Case in J2EE

259 Views

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