Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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

Matches any single character in a string comparison operation that involves pattern matching, such as LIKE and PATINDEX.

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

USE AdventureWorks2012;
GO
SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE '_an'
ORDER BY FirstName;

Community Additions

ADD
Show:
© 2015 Microsoft