Im currently trying to create a search functionality on the project I’m working on. Im having an issue when trying to search with multiple rows in single search query.

I have a user named “john wick” where “FirstName” is john “LastName” is wick I would like to search for this user with passing in 2 paremeters like this;

Select * from tblUser Where FirstName + LastName LIKE '%john wick%'

But this query doesnt work and is not returning the user. How can I solve this. This has be done by single parameter.

I have this query but not working.

Select * from tblUser Where FirstName + LastName LIKE '%john wick%'