MS SQL Server Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Use Wildcard Characters in LIKE Operations in MS SQL Server?
Answer:
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
GO
SELECT c.CompanyName FROM SalesLT.Customer c
WHERE c.CompanyName LIKE '%Sport% Store'
GO
CompanyName
-------------------------
Specialty Sports Store
Camping and Sports Store
Vigorous Sports Store
Our Sporting Goods Store
Sports Store
Sports Products Store
USE adventureWorksLT
GO
SELECT c.CompanyName FROM SalesLT.Customer c
WHERE c.CompanyName LIKE '%Sport% Store'
GO
CompanyName
-------------------------
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 Question | Next Question |
What To Perform Pattern Match with the LIKE Operator? | How To Test Subquery Results with the EXISTS Operator? |