Collections:
Using Wildcard Characters in LIKE Operations in SQL Server
How To Use Wildcard Characters in LIKE Operations in SQL Server Transact-SQL?
✍: FYIcenter.com
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
Â
⇒Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1464🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...