Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select clause where comparison String

Hello Experts,

I have an issue.

I have in the selection screen one Select-option without intervals.

This select-option for one filed NAME (String).

In my specific table, the name can be in upper case or low case or both like: Smith, SMITH or smith or SmiTh...

For my case, in the table i have: "Smith" and when i put Smith in the select-option, in debugg i have "SMITH" so in the query Select, it doesn't return anything.

Exists a way to do Select Upper(Field) = Parameter of the selection-screen?

Exist other way apart from do the selection with other criteria and after a Loop and compare the Upper (Field) with the parameter of the selection screen? I want do it in the query?

Thank you very much.

Former Member
Not what you were looking for? View more on this topic or Ask a question