WHERE Filters

What you’ll learn

• Common predicates: =, <>, BETWEEN, IN, LIKE, IS NULL.
• Sargability basics (avoid wrapping indexed columns).

SELECT *
FROM dbo.Products
WHERE Price BETWEEN 10 AND 20
  AND CategoryID IN (1,2,3)
  AND Discontinued = 0
  AND Name LIKE N'%Widget%'
  AND Color IS NOT NULL;

Notes

• LIKE '%prefix%' disables seeks; try LIKE N'prefix%' when possible.
• Avoid WHERE YEAR(OrderDate)=2025; prefer OrderDate >= '2025-01-01' AND OrderDate < '2026-01-01'.