Using Wildcard Characters in LIKE Operations in SQL Server

Q

How To Use Wildcard Characters in LIKE Operations in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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

⇑⇑ SQL Server Transact-SQL Tutorials

2017-01-21, 1963🔥, 0💬