SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
1 out of 1 rated this helpful - Rate this topic

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

SQL Server 2012

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.

Copy 
USE AdventureWorks2012;
GO
SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE '_an'
ORDER BY FirstName;
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.