Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

_ (Wildcard - Match One Character) (Transact-SQL)

Matches any single character in a string comparison operation that involves pattern matching, such as LIKE and PATINDEX. For more information, see Pattern Matching in Search Conditions.

The following example uses the _ operator to find all the people in the Contact table, who have a three-letter first name that ends in an.

USE AdventureWorks;
SELECT FirstName, LastName
FROM Person.Contact
WHERE FirstName LIKE '_an'
ORDER BY FirstName;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft