Working with the LIKE predicate

LikePredicatDemo.sql

-- The % (Percent) Wildcard
SELECT empid, lastname
FROM HR.Employees
WHERE lastname LIKE N'D%';

-- The _ (Underscores) Wildcard
SELECT empid, firstname, lastname
FROM HR.Employees
WHERE firstname LIKE N'___a';

-- The [<List of Characters>] Wildcard
SELECT empid, lastname
FROM HR.Employees
WHERE lastname LIKE N'[ABC]%';


-- The [<Character>-<Character>] Wildcard
SELECT empid, lastname
FROM HR.Employees
Where lastname LIKE N'[A-C]%';

-- The [^<Character List or Range>] Wildcard
SELECT empid, lastname
FROM HR.Employees
WHERE lastname LIKE N'[^A-C]%';