Any suggestions? Export (0) Print
Expand All

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


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 Dan.

-- Uses AdventureWorks

SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE 'Dan%';

Community Additions

© 2016 Microsoft