Answers

Question and Answer:

  Home  MS SQL Server

⟩ How To Use Wildcard Characters in LIKE Operations in MS SQL Server?

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

 140 views

More Questions for you: