Hi @adele vance ,
Welcome to Microsoft Q&A!
Please have a try with CONTAINS.
SELECT Name
FROM Production.Product
WHERE CONTAINS(Name, 'wheel');
CONTAINS finds all products that contain the word "Wheel" while FREETEXT searches for all products that contain words related to "Wheel".
You could refer more details in this link.
Best regards
Melissa
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.