MS SQL Server Concepts and Programming Question:
Download Questions PDF

How To Use Wildcard Characters in LIKE Operations in MS SQL Server?


Wildcard character '%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters. The following example uses '%Sport% Store' to search all company names that has a partial word 'Sport' and ended with the word 'Store'. The sample database AdventureWorksLT provided by Microsoft is used.

USE adventureWorksLT

SELECT c.CompanyName FROM SalesLT.Customer c
WHERE c.CompanyName LIKE '%Sport% Store'
Specialty Sports Store
Camping and Sports Store
Vigorous Sports Store
Our Sporting Goods Store
Sports Store
Sports Products Store

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
What To Perform Pattern Match with the LIKE Operator?How To Test Subquery Results with the EXISTS Operator?