Skip to Content

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

Select * from TABLE where Filed like pa_input.

Hello,

the following works fine

select * from ZTABLE INTO wa_myarea WHERE myfield LIKE 'a%'.

Now I don't want to hard code the selection criteria for myfield, but let the user select one, so I did:

parameters pa_input type mytype.

select * from ZTABLE INTO wa_myarea WHERE myfield LIKE pa_input.

If the user enters now for example a% everything works again fine. But I assume that a user rather would enter a* for a wild card search and that doesn't work. Do I have to manually replace all * in my variable with % before I run the select statement? I hope not... What would be the best way?

Thanks.

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