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)
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
-- Uses AdventureWorks SELECT FirstName, LastName FROM Person.Person WHERE FirstName LIKE 'Dan%'; GO