SQL LIKE operator with parameters and wildcards

Question posted 2012 · +6 upvotes

I have a query where I want to return all Clients that have a certain string in the name with wildcards on either side. So the input could be “Smith” and i want to return all things like “The John Smith Company” or “Smith and Bros”. I want [Client] to be prompted so I set up the SQL like this:

PARAMETERS Client Text ( 255 );
SELECT *
WHERE (((tbl_IncomingChecks.Client) Like'%' + [Client] + '%') 
ORDER BY tbl_IncomingChecks.Client;

The query is not returning any results. Please help