Implement Like or Contains Clause in SQL Server

Dear @iammann,

       Please refer below articles, it might be help you

https://stackoverflow.com/questions/14290857/sql-select-where-field-contains-words

https://www.c-sharpcorner.com/blogs/how-to-check-if-a-string-contains-a-substring-in-sql-server

https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql

Refert the below link for your reference.

https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql

This is an example of Contains using LIKE command.

SELECT Name FROM Customers
WHERE Name LIKE '%' + 'John' + '%'