>>SELECT *
>>  FROM vw.foo  f
>>  WHERE f.cost_center LIKE
>>    CASE WHEN @cost_center = 'ALL' THEN '%' ELSE @cost_center END
>>