Implement Like or Contains Clause in SQL Server

Last Reply on Mar 16, 2018 07:13 AM By Mudassar

Posted on Mar 16, 2018 05:39 AM

i want to use contains clause in sql .but i dont know how to implement .please refer any code or example.

thanks



Posted on Mar 16, 2018 07:13 AM

This is an example of Contains using LIKE command.

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