use
LIKE operator:
Like Operator is used in a WHERE clause to search for a specified pattern in a column.
% :- A substitute for zero or more characters
_ :- A substitute for a single character
[charlist] :- Sets and ranges of characters to match
[^charlist] or [!charlist] :- Matches only a character NOT specified within the brackets
SELECT ID,Name,Price,Quantity From Products WHERE Name LIKE '%Fox%'