Home Library Learn Downloads Support Community
Sign in | United States - English | |
1 out of 1 rated this helpful - Rate this topic

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

SQL Server 2008

Matches any single character that is not within the range or set specified between the square brackets. For more information, see Pattern Matching in Search Conditions.

The following example uses the [^] operator to find all the people in the Contact table who have first names that start with Al and have a third letter that is not the letter a.

Copy 
USE AdventureWorks;
GO
SELECT FirstName, LastName
FROM Person.Contact
WHERE FirstName LIKE 'Al[^a]%'
ORDER BY FirstName;
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ