postgresql7.1
select dotlrn_users.user_id,
dotlrn_users.first_names,
dotlrn_users.last_name,
dotlrn_users.email,
dotlrn_privacy__guest_p(dotlrn_users.user_id) as guest_p,
acs_permission__permission_p(:root_object_id, dotlrn_users.user_id, 'admin') as site_wide_admin_p
from dotlrn_users
where upper(substr(dotlrn_users.last_name, 1, 1)) = :section
order by dotlrn_users.last_name
select dotlrn_users.user_id,
dotlrn_users.first_names,
dotlrn_users.last_name,
dotlrn_users.email,
dotlrn_privacy__guest_p(dotlrn_users.user_id) as guest_p,
acs_permission__permission_p(:root_object_id, dotlrn_users.user_id, 'admin') as site_wide_admin_p
from dotlrn_users
where upper(substr(dotlrn_users.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
order by dotlrn_users.last_name