Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Using Wildcard Characters in LIKE Operations
(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.
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 Products Store
(Continued on next topic...)
- What Is a Boolean Value?
- What Are Conditional Expressions?
- What Are Comparison Operations?
- How To Perform Comparison on Exact Numbers?
- How To Perform Comparison on Floating Point Numbers?
- How To Perform Comparison on Date and Time Values?
- How To Perform Comparison on Character Strings?
- What To Test Value Ranges with the BETWEEN Operator?
- What To Test Value Lists with the IN Operator?
- What To Perform Pattern Match with the LIKE Operator?
- How To Use Wildcard Characters in LIKE Operations?
- How To Test Subquery Results with the EXISTS Operator?
- How To Test Values Returned by a Subquery with the IN Operator?
- What Are Logical/Boolean Operations?