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

Percent character (Wildcard - Character(s) to Match) (Transact-SQL)

SQL Server 2012

Matches any string of zero or more characters. This wildcard character can be used as either a prefix or a suffix.

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

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

Community Additions

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