Upper and Lower Case in J2EE

[former_member187444]

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></u>

Best Regards

Eray

[Former Member · Accepted solution]

Hi

here you can find all the functions permitted in the OpenSQL:

http://help.sap.com/saphelp_nw04/helpdata/en/9b/f46cabaa874bc9a82234e8cf1d0696/frameset.htm

So I think that Upper/Lower are not permitted... the work around is to get all the records and check the Upper and Lower case using Java Code functions into your business methods.

Hoper this help.

Vito

[michael_goeck · Accepted solution]

Hi,

so it is not possible to make such a case-insensitive SELECT? Is there a way to work around this limitation? Saving all values as uppercase is not an option

Maybe with NativeSQLAccess (com.sap.sql.NativeSQLAccess)?

Thanks & regards,

Michael