Export (0) Print
Expand All

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

Matches any single character that is not within the range or set specified between the square brackets.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

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.

USE AdventureWorks2012;
GO
SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE 'Al[^a]%'
ORDER BY FirstName;

Community Additions

ADD
Show:
© 2014 Microsoft