oracle8.1.6 select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id from cc_users u where upper(nvl(u.first_names || ' ', '') || nvl(u.last_name || ' ', '') || u.email || ' ' || nvl(u.screen_name, '')) like upper('%'||:value||'%') and not exists (select 1 from acs_rels where object_id_one = $group_id and object_id_two = u.user_id) order by name