WHEN DATEDIFF(yy,BirthDate,getdate()) < 20 THEN 'Under 20' WHEN DATEDIFF(yy,BirthDate,getdate()) < 40 THEN '20 - 39' WHEN DATEDIFF(yy,BirthDate,getdate()) < 60 THEN ...