Query not working

[yasmalik]

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

[vinakumar · Accepted 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]] || '%'