postgresql7.1 select CASE WHEN parties.email is not null THEN contact__name(persons.person_id) || ' <' || parties.email || '>' ELSE contact__name(persons.person_id) END || to_char(persons.person_id,' #FM999999999999999999999999'), persons.person_id from persons, parties, group_distinct_member_map where persons.person_id = parties.party_id and persons.person_id = group_distinct_member_map.member_id and group_distinct_member_map.group_id in ([template::util::tcl_to_sql_list [contacts::default_groups -package_id $package_id]]) [contact::search::query_clause -and -query $query -party_id "persons.person_id"] order by upper(persons.first_names) asc, upper(persons.last_name) asc limit 51 select contact__name(organizations.organization_id) || to_char(organizations.organization_id,' #FM999999999999999999999999'), organizations.organization_id from organizations, parties, group_distinct_member_map where organizations.organization_id = parties.party_id and organizations.organization_id = group_distinct_member_map.member_id and group_distinct_member_map.group_id in ([template::util::tcl_to_sql_list [contacts::default_groups -package_id $package_id]]) [contact::search::query_clause -and -query $query -party_id "organizations.organization_id"] order by upper(organizations.name) asc limit 51