This topic has not yet been rated - Rate this topic

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

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005
SQL Server 2012

Matches any string of zero or more characters. This wildcard character can be used as either a prefix or a suffix. For more information, see Pattern Matching in Search Conditions.

Examples

The following example returns all the first names of people in the Person table of AdventureWorks2008R2 that start with Dan.

USE AdventureWorks2008R2;
GO
SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE 'Dan%';
GO

Reference

LIKE (Transact-SQL)

Operators (Transact-SQL)

Expressions (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD