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
⇒ EXISTS - Testing Subquery Results in SQL Server
⇐ LIKE - Matching a Pattern in a Character String in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1685🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...