1 out of 2 rated this helpful - Rate this topic

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

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005
SQL Server 2012

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.

Examples

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 AdventureWorks2008R2;
GO
SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE '_an'
ORDER BY FirstName;

Reference

LIKE (Transact-SQL)

PATINDEX (Transact-SQL)

% (Wildcard - Character(s) to Match) (Transact-SQL)

[ ] (Wildcard - Character(s) to Match) (Transact-SQL)

[^] (Wildcard - Character(s) Not to Match) (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD