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, 843👍, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, y...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...