(Wildcard - Character(s) Not to Match) (Transact-SQL)
Updated: December 6, 2016
Applies To: Azure SQL Database, SQL Server (starting with 2008)
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
-- Uses AdventureWorks SELECT FirstName, LastName FROM Person.Person WHERE FirstName LIKE 'Al[^a]%' ORDER BY FirstName;