Query not working

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

Best answer by vinakumar

Hi ,

you should prepare your query like below if you are using two wild cards together.

select * from user_model where name like '%' || [[UserName]] || '%'

Answer

12-Amethyst

Hi ,

you should prepare your query like below if you are using two wild cards together.

select * from user_model where name like '%' || [[UserName]] || '%'

Sign up