topic Re: How to use Upper in a select statement from database table in Application Development and Automation Discussions

How to use Upper in a select statement from database table

former_member863502 — Tue, 16 May 2023 04:48:41 GMT

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).

Re: How to use Upper in a select statement from database table

_4ndr3as_ — Tue, 16 May 2023 05:24:24 GMT

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

Re: How to use Upper in a select statement from database table

Sandra_Rossi — Tue, 16 May 2023 06:21:54 GMT

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.