Select clause where comparison String
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.