Wildcard character'%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters.

for example:

SELECT c.CompName FROM Company c
WHERE c.CompName LIKE '%Mind% Stick'