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, 1563🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...