Hello. I'm working on a project that a data table stores a list of specific client names and their ID numbers and the users need to query the data table to see if the client they are working with are on this list. If so, these clients get a discount, if not, they pay full price. The people I'm developing this for would like to use a single word search term to look for their clients. Currently, if the client name is only one word long, the client can be found. I would like to use something similar to the query below, but not 100% sure on the syntax:
SELECT * FROM ClientTable WHERE ClientName LIKE myVariable
"myVariable" would contain any one word search term the users typed into an input box.