At least one result from the case expression must return a value other than null. The following query:
select price, 
    case
        when title_id like "%" then NULL
        when pub_id like "%" then NULL
    end
from titles
returns the error message:
All result expressions in a CASE expression must not be NULL