How to use Upper in a select statement from database table

[former_member863502]

Hello,

I want to select entries from table adr6 where Upper(smtp_addr) in @s_addr.

This is my code, what modification is needed? How can I use Upper in a select statement from database table?

SELECT addrnumber, persnumber, smtp_addr FROM adr6
                                         FOR ALL ENTRIES IN @lt_adddr
                                         WHERE addrnumber = @lt_adddr-addrnumber
                                         AND smtp_addr IN @s_addr
                                        INTO TABLE @DATA(lt_adr6).

[former_member863502]

Hello,

I want to select entries from table adr6 where Upper(smtp_addr) in @s_addr.

This is my code, what modification is needed? How can I use Upper in a select statement from database table?

SELECT addrnumber, persnumber, smtp_addr FROM adr6
                                         FOR ALL ENTRIES IN @lt_adddr
                                         WHERE addrnumber = @lt_adddr-addrnumber
                                         AND smtp_addr IN @s_addr
                                        INTO TABLE @DATA(lt_adr6).

[_4ndr3as_]

Ciao Imen,

maybe you can use CAST to move info to a uppercase data element. SQL Expressions, Cast Expression - ABAP Keyword Documentation (sap.com). Not sure if this works, but it's a try.

Regards Andreas

[Sandra_Rossi]

This is the link: sql_cond - IN range_tab for

SELECT ... WHERE ... operand IN ranges_table ...

For operand, the doc says:

• The following applies to operand:
  • SQL expressions except for aggregate expressions and window expressions can be specified.
  • In a HAVING clause, aggregate expressions can also be used.