select "first_name", "last_name",ifnull(another_first_name,' ','& '||"another_first_name") another_first_name,"another_last_name", "address_1","city","state","zip",ifnull(home_phone,' ','H.'||"home_phone") home_phone,ifnull(work_phone,' ','W.'||"work_phone") work_phone,ifnull(beeper,' ','B.'||"beeper") beeper from "dba"."address_book" where "krewe" = 'Y' order by "last_name"