SELECT contactname, IFNULL(bizphone, homephone) phone FROM contacts;
SELECT * from TABLE where CODE IS NULL OR CODE!='C'