Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Select * from TABLE where Filed like pa_input.

Former Member
0 Kudos

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.

1 REPLY 1

Former Member
0 Kudos

Moderator message - Please do not ask basic questions - thread locked Rob