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