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

APPLIES TO: yesSQL Server (starting with 2008) yesAzure SQL Database noAzure 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%';  

See Also

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