Matches any single character that is not within the range or set specified between the square brackets.
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
.
-- Uses AdventureWorks
SELECT FirstName, LastName
FROM Person.Person
WHERE FirstName LIKE 'Al[^a]%'
ORDER BY FirstName;
LIKE (Transact-SQL)
PATINDEX (Transact-SQL)
% (Wildcard - Character(s) to Match) (Transact-SQL)
[ ] (Wildcard - Character(s) to Match) (Transact-SQL)
_ (Wildcard - Match One Character) (Transact-SQL)