% (Wildcard - Character(s) to Match) (Transact-SQL)
Matches any string of zero or more characters. This wildcard character can be used as either a prefix or a suffix. For more information, see Pattern Matching in Search Conditions.
The following example returns all the first names of people in the
Contact table of
AdventureWorks that start with
USE AdventureWorks; GO SELECT FirstName, LastName FROM Person.Contact WHERE FirstName LIKE 'Dan%'; GO