Edit

Share via

Percent character (wildcard - character(s) to match) (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

Matches any string of zero or more characters. This wildcard character can be used as a prefix, a suffix, or in the middle of the string. The pattern string can contain more than one % wildcard.

Examples

Example A: Match end of string

The following example returns the first and last names of people in the Person.Person table of AdventureWorks2022, where the first name starts with Dan.

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

Example B: Match middle of string

The following example returns the first and last names of people in the Person.Person table of AdventureWorks2022, where the first name starts with J and ends with n.

SQL 
SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE 'J%n';
GO

See also