cancel
Showing results for 
Search instead for 
Did you mean: 

Case insesitive String comparison in Open SQL

Former Member
0 Kudos

Is case insensitive string comparison in SAP's OpenSQL possible ? Eg i have SQL query where string comparisons are case sensitive:

SELECT pk1 FROM table1 WHERE str1 = str2;

and i would like to get something that is compatible with OpenSQL and behaves similar to MySQL's query:

SELECT pk1 FROM table1 WHERE LOWER(str1) = LOWER(str2);

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I think both LOWER and UPPER functions are supported.

You may test it by executing the following query

select UPPER('I love OpenSQL') from DUAL

Should be working

HTH

Peter

Former Member
0 Kudos

Unfortunately this functions are not supported in OpenSQL. I get an error message:

The SQL statement "select UPPER(propval) from BCC_POIPROVAL" contains the syntax error[s]: Intermediate-SQL syntax error: UPPER or LOWER function not allowed.

Kind regards,

Marcin Zduniak