Export (0) Print
Expand All
Expand Minimize
4 out of 6 rated this helpful - Rate this topic

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

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.

Topic link icon Transact-SQL Syntax Conventions

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

USE AdventureWorks;
GO
SELECT FirstName, LastName
FROM Person.Contact
WHERE FirstName LIKE 'Dan%';
GO
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.