SQL Server WHERE Clause and Filtering: LIKE Clause Tutorial

Filter Customers by Email Domain

Write a query to find all customers whose email ends with '@example.com' using the LIKE clause.

Expected output: A list of customers with emails ending in '@example.com'.

Hint: Use the % wildcard to match any characters before '@example.com'.

Find Products Starting with 'S' and Ending with 'r'

Write a query to find products where the name starts with 'S' and ends with 'r'.

Expected output: Products like 'Speaker', 'Scanner', etc.

Hint: Use LIKE with % wildcard and appropriate pattern.

Search for Names with Exactly Four Characters

Write a query to find all employees whose first names have exactly four characters.

Expected output: Employees with four-letter first names.

Hint: Use the _ wildcard to match single characters.

% matches zero or more characters, while _ matches exactly one character.

You can use a case-sensitive collation in the query, for example: WHERE column LIKE pattern COLLATE Latin1_General_CS_AS.

Avoid leading wildcards (%) as they prevent index usage and cause full table scans, slowing down queries.