cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Query not working

yasmalik
9-Granite

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 itCapture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

Hi ,

 

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

 

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

View solution in original post

1 REPLY 1

Hi ,

 

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

 

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

View solution in original post

Announcements