select FirstName, LastName, WorkPhone, case when WorkPhone is null then HomePhone end as HomePhone from Members;