Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
I have one parameter and i am trying to put like operator in sql query but it is not working please help to resolve it
Solved! Go to Solution.
Hi ,
you should prepare your query like below if you are using two wild cards together.
select * from user_model where name like '%' || [[UserName]] || '%'
Hi ,
you should prepare your query like below if you are using two wild cards together.
select * from user_model where name like '%' || [[UserName]] || '%'