Case-insensitive comparison in SELECT condition

Question

In ABAP SQL can I ignore the case when comparing fields in the WHERE clause of a SELECT?

SELECT * 
FROM some_table 
WHERE field1 = variable1.

How can I compare field1 to variable1 ignoring different case?

Thank you for your guys' help. I use native sql as my solution. — Dustin Sun, Jun 30 '11 at 14:24

score 6 · Answer 1 · edited Mar 05 '21 at 12:08

6

Open SQL can do this with the function UPPER starting ABAP 7.51.

Example:

SELECT * 
FROM some_table 
WHERE UPPER( field1 ) = @variable1
INTO TABLE @DATA(internal_table).

edited Mar 05 '21 at 12:08

Mike

14,010
29
101
161

answered Aug 08 '18 at 16:04

Psio

83
2
5

1

happy to know. I have been waiting this feature for quite a few years. – Dustin Sun Aug 08 '18 at 19:38

score 4 · Accepted Answer · answered Jun 22 '11 at 18:15

Depending on the table you are selecting from, you may be lucky in that SAP is storing the same value in a related matchcode field, in which the value would always be upper case.

Otherwise, you may find something in the documentation of the underlying DB that allows such a search, in which case you may issue a native SELECT.

For example, if your SAP system uses Oracle as the underlying DB, you can refer to this article: http://www.dba-oracle.com/oracle_news/2005_5_20_great_technique_case_sensitive_text_searching.htm

An example of the first paragraph would be tables `EQUI` and `EQKT`. The field `EQKTU`. stores the upper case description. — Eduardo Copat, Jul 19 '21 at 04:01

score 2 · Answer 3 · answered Jun 29 '11 at 07:48

2

You can't. Open SQL does not support case insensitive conditions.

You can either do what mydoghasworms suggested or you filter your results using regex after data selection.

answered Jun 29 '11 at 07:48

Six Beacon Gaia

170
5

Hartmut Pfarr · Answer 4 · 2011-07-04T11:33:48.540

1

OpenSQL can't do this - like the others mentioned alreay in earlier statements.

But there is one alternative: Native SQL, the "upper" function, means:

translate compare_value to upper case.

exec sql performing addX.
  select * FROM  INTO :workarea
   where upper("choose_column") eq :compare_value
endexec.

form addX.
  append workarea to itab.
endform.

edited Jul 04 '11 at 11:33

answered Jul 02 '11 at 23:33

Hartmut Pfarr

5,534
5
36
42

Case-insensitive comparison in SELECT condition

4 Answers4