Nevermind.. It should be: CASE WHEN r.Footage >= 200 AND r.AllocatedBy Is Null THEN [r.Footage] ELSE 0 END AS lengthsmore225, sorry.