on 08-03-2006 1:28 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.