Percent character (Wildcard - Character(s) to Match) (Transact-SQL)

 

Updated: December 6, 2016

Applies To: Azure SQL Data Warehouse, Azure SQL Database, SQL Server (starting with 2008)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Matches any string of zero or more characters. This wildcard character can be used as either a prefix or a suffix.

The following example returns all the first names of people in the Person table of AdventureWorks2012 that start with Dan.

-- Uses AdventureWorks  
  
SELECT FirstName, LastName  
FROM Person.Person  
WHERE FirstName LIKE 'Dan%';  
GO  

LIKE (Transact-SQL)
Operators (Transact-SQL)
Expressions (Transact-SQL)
[ ] (Wildcard - Character(s) to Match)
[^] (Wildcard - Character(s) Not to Match)
_ (Wildcard - Match One Character)

Community Additions

ADD
Show: