Percent character (wildcard - character(s) to match) (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
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
.
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
.
SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE 'J%n';
GO
See also
משוב
https://aka.ms/ContentUserFeedback.
בקרוב: במהלך 2024, נפתור בעיות GitHub כמנגנון המשוב לתוכן ונחליף אותו במערכת משוב חדשה. לקבלת מידע נוסף, ראה:שלח והצג משוב עבור