Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. 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]] || '%'