The question is how to return the text that I want from my parameter? Means I want to look for a certain word in the name of a company and the query will run the companies' name that contain that word.
I don't want to specify the word in my SQL statement I want to leave it open. I've done it with a date and the criteria for the parameter is:
In SQL it's translated like this:
WHERE Table.OrderDate = [Date:]
And I will enter the date that I want. Is there a way to do it with text to return all the companies' names containing the word that I want on my parameter?