oracle8.1.6 select acs_object.name(:object_id) from dual select p.party_id, acs_object.name(p.party_id) || nvl2(p.email, ' ('||p.email||')', '') as name from parties p order by upper(acs_object.name(p.party_id))