Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Using Wildcard Characters in LIKE Operations

By: FYIcenter.com

(Continued from previous topic...)

How To Use Wildcard Characters in LIKE Operations?

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

(Continued on next topic...)

1. What Is a Boolean Value?
2. What Are Conditional Expressions?
3. What Are Comparison Operations?
4. How To Perform Comparison on Exact Numbers?
5. How To Perform Comparison on Floating Point Numbers?
6. How To Perform Comparison on Date and Time Values?
7. How To Perform Comparison on Character Strings?
8. What To Test Value Ranges with the BETWEEN Operator?
9. What To Test Value Lists with the IN Operator?
10. What To Perform Pattern Match with the LIKE Operator?
11. How To Use Wildcard Characters in LIKE Operations?
12. How To Test Subquery Results with the EXISTS Operator?
13. How To Test Values Returned by a Subquery with the IN Operator?
14. What Are Logical/Boolean Operations?